Will data cached in a warehouse be lost when the warehouse is resized?
A.
Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
B.
Yes. because the compute resource is replaced in its entirety with a new compute resource.
C.
No. because the size of the cache is independent from the warehouse size
D.
Yes. became the new compute resource will no longer have access to the cache encryption key
The Answer Is:
C
This question includes an explanation.
Explanation:
When a Snowflake virtual warehouse is resized, the data cached in the warehouse is not lost. This is because the cache is maintained independently of the warehouse size. Resizing a warehouse, whether scaling up or down, does not affect the cached data, ensuring that query performance is not impacted by such changes.