Answer-first summary for fast verification
Answer: Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
The correct answer is A based on Snowflake documentation and community consensus. When a warehouse is resized to a smaller size, compute resources are removed, and the cache associated with those removed resources is dropped. This is explicitly stated in Snowflake's documentation about warehouse considerations. Option B is incorrect because it suggests cache is always lost during any resize operation, but the documentation specifies this only happens when decreasing warehouse size. Option C is incorrect because cache size is dependent on warehouse size - larger warehouses have more cache capacity. Option D is incorrect as cache encryption keys are not the reason for cache loss during resizing.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Will data cached in a virtual warehouse be lost if 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, because the new compute resource will no longer have access to the cache encryption key.