Will data cached in a warehouse be lost when the warehouse is resized?

The correct answer is C. No. because the size of the cache is independent from the warehouse size. When a Snowflake virtual warehouse is resized, the local SSD disk cache (used for caching query results and micro-partition data) is preserved on the existing compute nodes. Resizing a warehouse does not destroy or replace the entire compute cluster in a way that would flush…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

APossibly, if the warehouse is resized to a smaller size and the cache no longer fits.
BYes. because the compute resource is replaced in its entirety with a new compute resource.
CNo. because the size of the cache is independent from the warehouse size
DYes. became the new compute resource will no longer have access to the cache encryption key

How the community answered

(36 responses)

B
3% (1)
C
94% (34)
D
3% (1)

Explanation

When a Snowflake virtual warehouse is resized, the local SSD disk cache (used for caching query results and micro-partition data) is preserved on the existing compute nodes. Resizing a warehouse does not destroy or replace the entire compute cluster in a way that would flush the cache. New nodes added during a scale-up start with an empty cache, but existing nodes retain theirs. This differs from suspending and resuming a warehouse, which DOES clear the cache entirely. Therefore, resizing alone does not cause a full cache loss.

Topics

#Warehouses#Caching#Architecture#Data Persistence

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice