Snowpro Core · Free Practice Question Easy
Question 11
Which of the following caching mechanisms in Snowflake does not require virtual warehouses to be active for it to work?
-
A
Query Result Cache
-
B
Clustering Cache
-
C
Data Cache (Micro-partition Cache)
-
D
Metadata Cache
Reveal correct answer
Correct answer: A
A.
The Query Result Cache stores the results of executed queries for 24 hours. If the same query is executed again within this timeframe, Snowflake can return the cached result without needing to activate a virtual warehouse, thereby saving compute resources and reducing latency.
B.
The Clustering Cache stores information related to table clustering keys, which are used to optimize query performance by minimizing the amount of data scanned. This cache is utilized in conjunction with active virtual warehouses to efficiently process clustered tables.
C.
This cache stores data retrieved from disk storage, specifically micro-partitions of tables. It is tied to active virtual warehouses, meaning that for the cache to be utilized, a virtual warehouse must be running to process queries and manage the cached data.
D.
The Metadata Cache holds information about database objects like table schemas, view definitions, and other metadata. While it speeds up query planning and optimization, accessing this cache typically involves interactions with active virtual warehouses during query execution.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
