Answer-first summary for fast verification
Answer: The cache is dropped when the warehouse is suspended and is no longer available upon restart.
According to Snowflake documentation and the community consensus with 100% agreement and upvoted comments, when a virtual warehouse is suspended, the warehouse cache is dropped and is no longer available upon restart. This is explicitly stated in Snowflake's official documentation on warehouse considerations and performance caching. Option A correctly describes this behavior. Option B is incorrect because the cache does not persist through suspension. Option C is incorrect as there is no two-hour cache retention period. Option D is incorrect because the cache is not maintained for the auto_suspend duration.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
If a virtual warehouse is suspended, what happens to the warehouse cache?
A
The cache is dropped when the warehouse is suspended and is no longer available upon restart.
B
The warehouse cache persists for as long as the warehouse exists, regardless of its suspension status.
C
The cache is maintained for up to two hours and can be restored if the warehouse is restarted within this limit.
D
The cache is maintained for the auto_suspend duration and can be restored if the warehouse is restarted within this limit.
No comments yet.