SnowPro Core Certification — Question 894

If a virtual warehouse is suspended, what happens to the warehouse cache?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because when a virtual warehouse is suspended, its cache is indeed dropped and cannot be recovered upon restart. Options B and C are incorrect as they imply persistence beyond suspension, while D inaccurately suggests the cache lasts during the auto_suspend period.