Snowflake SnowPro Certification Practice Test

In Snowflake, what is the default auto_suspend time for a warehouse?

1. 5 seconds

2. 60 seconds

3. 15 minutes

4. No default setting

The correct answer is: 15 minutes

The default auto_suspend time for a warehouse in Snowflake is set to 60 seconds. This means that if a warehouse is not actively processing any queries, it will automatically suspend itself after 60 seconds of inactivity. Setting an auto_suspend time helps manage resources effectively and controls costs, as actively running warehouses incur charges. By having this default setting, Snowflake optimizes resource utilization without requiring users to manually suspend warehouses when they are not in use. It's important to distinguish this from other options, such as an option suggesting that there is no default setting at all, which overlooks the built-in features Snowflake provides for automating warehouse management. Additionally, shorter times like 5 seconds would likely be impractical in real-world scenarios where users may need a few moments of inactivity before a warehouse can be suspended safely. Similarly, options like 15 minutes are longer than the default, which emphasizes the need for timely suspension to save costs.