Level Up: Step 3 - Caching

Which cache stores object definitions and statistics? Select the correct options from the list A. Metadata Cache B. Results Cache C. Warehouse Cache

A. Metadata Cache

Which of the following could be considered synonymous with the term "Warehouse Cache"? (Choose 3) Select the correct options from the list A. Metadata Cache B. Raw Data Cache C. Result Set Cache D. SSD Cache E. Data Cache

B. Raw Data Cache D. SSD Cache E. Data Cache

Which cache type runs on a 24 hour "clock"? Select the correct options from the list A. Metadata Cache B. Results Cache C. Warehouse Cache

B. Results Cache

What action causes a Warehouse's cache to be purged? Select the correct options from the list A. Resuming the warehouse. B. Suspending the warehouse. C. The passing of 24 hours. D. A change to the Metadata Cache size.

B. Suspending the warehouse.

User A and User B can access one another's result sets from the Results Cache, as long as which of the following are true? (Choose two) Select the correct options from the list A. They use the same Warehouse. B. They run the exact same SQL Text/Query. C. They sign in to the same Session. D. They use the same Role. E. They run with 59 minutes of one another.

B. They run the exact same SQL Text/Query. D. They use the same Role.

You are viewing the Query History table in the History area of the WebUI. You want to see if a query pulled data from long-term centralized storage. Where will you look and what will you look for? Select the correct options from the list A. Look in the Bytes Scanned column for the acronym LTCS. B. Look in the Rows column for a red bar. C. Look in the Bytes Scanned column for a green bar. D. Look in the Rows column for the acronym LTCS.

C. Look in the Bytes Scanned column for a green bar.

Which cache type gets purged in a predictable way so that it ends up empty of all cached information? Select the correct options from the list A. Metadata Cache B. Results Cache C. Warehouse Cache

C. Warehouse Cache

There are four data locations covered in the caching video. Three are caches and the other is long-term centralized storage. Which of the four locations require a running warehouse when retrieving data from them? Select the correct options from the list A. Metadata Cache B. Results Cache C. Warehouse Cache D. Centralized Storage

C. Warehouse Cache D. Centralized Storage