If a virtual warehouse is suspended, what happens to the warehouse cache?
If a virtual warehouse is suspended, what happens to the warehouse cache?
When a virtual warehouse is suspended, the cache associated with it is dropped and is no longer available upon restart. This results in potentially slower performance for initial queries after the warehouse is resumed.
A is correct
https://docs.snowflake.com/en/user-guide/warehouses-considerations This cache is dropped when the warehouse is suspended, which may result in slower initial performance for some queries after the warehouse is resumed. https://docs.snowflake.com/en/user-guide/performance-query-warehouse-cache The auto-suspension setting of the warehouse can have a direct impact on query performance because the cache is dropped when the warehouse is suspended.
Answer - A