Level Up: Step 1 - Query & Results History

FDNEIGE is running queries using SYSADMIN and ACCOUNTADMIN roles. User ALICE is using the PUBLIC Role. Select all true statements. Select the correct options from the list A. FDNEIGE can see all of ALICE's queries. B. ALICE can see all of FDNEIGE's queries. C. FDNEIGE can see all of ALICE's results. D. ALICE can see FDNEIGE's results only when they were run using SYSADMIN role. E. ALICE cannot see any other user's queries because PUBLIC is the lowest role. F. FDNEIGE can see all other user's queries when her role is set to ACCOUNTADMIN.

A. FDNEIGE can see all of ALICE's queries. B. ALICE can see all of FDNEIGE's queries.

A query you initiated is taking too long. You've gone into the History area to check whether this query (which usually runs every hour) is supposed to take a long time. Check all true statements. Select the correct options from the list A. Information in the History area can be filtered to show a single Warehouse. B. Information in the History area can be filtered to show a single User. C. Information in the History area can be filtered to show a single Session. D. Information in the History area can help you visually compare query times. E. If you decide to end the query, you must return to the worksheet to Abort the query.

A. Information in the History area can be filtered to show a single Warehouse. B. Information in the History area can be filtered to show a single User. C. Information in the History area can be filtered to show a single Session. D. Information in the History area can help you visually compare query times.

You have a dashboard that connects to Snowflake via JDBC. The dashboard is refreshed hundreds of times per day. The data is very stable, only changing once or twice per day. The query run by the dashboard connector user never changes. How will Snowflake manage changing and non-changing data? Select all true statements. A. Snowflake will show the most up-to-date data each time the dashboard is refreshed.. B. Snowflake will spin up a warehouse each time the dashboard is refreshed. C. Snowflake will spin up a warehouse only if the underlying data has changed. D. Snowflake will compile results cache data from all user results so no warehouse is needed. E. Snowflake will re-use data from the Results Cache as long as it is still the most up-to-date data available.

A. Snowflake will show the most up-to-date data each time the dashboard is refreshed.. C. Snowflake will spin up a warehouse only if the underlying data has changed. E. Snowflake will re-use data from the Results Cache as long as it is still the most up-to-date data available.

When running a SELECT COUNT(*) on a table, which of the following statements is true? Select the correct options from the list A. Only an XS Warehouse will be needed because Count statistics are stored in the Results Cache. B. No Warehouse will be needed because Count statistics are stored in the Metadata Cache. C. No Warehouse will be needed because all Users share Count statistics. D. Only an XS Warehouse will be needed because all Roles share Count statistics.

B. No Warehouse will be needed because Count statistics are stored in the Metadata Cache.

Using the History area of the WebUI, how far back in time is query history available? Select the correct options from the list A. Infinite B. A calendar month C. 14 days D. 7 days E. 24 hours

C. 14 days

An hour ago, you ran a complex query. You then ran several simple queries from the same worksheet. You want to export the results from the complex query but they are no longer loaded in the Results pane of the worksheet. What is the least costly way to download the results? Select the correct options from the list A. Click on History -> Locate the Query -> Click "Download Results" in column 3 B. Type the command SELECT RESULTS(-3) into the Worksheet and click "Run" C. Click on History -> Locate the Query -> Click the QueryID -> Use the "Export Result" button D. Type the command Select RESULTS(<Account>,<User>,<QueryID>) in the Worksheet and click "Run"

C. Click on History -> Locate the Query -> Click the QueryID -> Use the "Export Result" button

The columns in the query history include the QueryID, the SQL Text, the Warehouse name, the Warehouse Size, the Session ID and others. Which column is a good indicator of whether a Warehouse was used (and Compute costs incurred) by a query? Select the correct options from the list A. QueryID B. SQL Text C. Warehouse Name D. Size E. Session ID

D. Size