Snowflake Certification Practice Test

Does warehouse cache get reset if the Virtual Warehouse is suspended and resumed?

1. Yes

2. No

3. Only if the resume time exceeds an hour

4. It depends on system load

The correct answer is: Yes

When a Virtual Warehouse in Snowflake is suspended and then resumed, the warehouse cache does get reset. This behavior occurs because suspending a Virtual Warehouse clears its cache, which includes data that has been cached during queries executed while the warehouse is active. Upon resuming, the warehouse starts with a fresh cache, thereby requiring queries to re-fetch data from the underlying storage if necessary. This design ensures that the cache reflects the most current data available in the Snowflake environment and provides efficient query performance when the warehouse is actively processing requests. Therefore, it's crucial for users to understand that any caching benefits gained during prior executions will be lost once the warehouse is suspended, and they may notice some performance implications as new data is loaded into the cache after resumption.