SnowPro Core Certification — Question 138

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

Answer options

• 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, because the new compute resource will no longer have access to the cache encryption key.

Correct answer: A

Explanation

The correct answer is A, as resizing a warehouse to a smaller size may lead to loss of cached data if it exceeds the new capacity. Option B is incorrect because while the compute resource is replaced, it does not guarantee loss of all cached data. Option C is wrong since the cache size can be affected by the warehouse size. Option D is also incorrect because cache encryption keys are typically managed separately from the compute resources.