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

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

View Answer

Answer: C

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.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Virtual Warehouse Performance1