COF-C02 Question #509: Real Exam Question with Answer & Explanation

Question

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

Options

• AThe cache is dropped when the warehouse is suspended and is no longer available upon restart.
• BThe warehouse cache persists for as long the warehouse exists, regardless of its suspension
• CThe cache is maintained for up to two hours and can be restored If the warehouse Is restarted
• DThe cache is maintained for the auto suspend duration and can be restored it the warehouse 15

Explanation

When a virtual warehouse in Snowflake is suspended, the cache is dropped and is no longer available upon restart. This means that all cached data, including results and temporary data, are cleared from memory. The purpose of this behavior is to conserve resources while the warehouse is not active. Upon restarting the warehouse, it will need to reload any data required for queries from storage, which may result in a slower initial performance until the cache is repopulated. This is a critical consideration for managing performance and cost in Snowflake.

No community discussion yet for this question.