SOL-C01 practice question 28 of 30
What is the purpose of the "auto-suspend" feature in Snowflake virtual warehouses?
Full set: 214 questionsThe auto-suspend feature is a cost-management tool in Snowflake. It automatically suspends a virtual warehouse (i.e., shuts down its compute resources) if it remains idle for a specified period. This stops credit consumption for the warehouse until it is needed again, at which point it resumes automatically when a new query is submitted. This ensures that you only pay for compute resources when they are actively being used.
A. Automatically increasing the warehouse size is known as resizing, which is a manual or programmatic action, not auto-suspend.
C. Automatically adding more nodes (clusters) is a feature of multi-cluster warehouses called auto-scaling, not auto-suspend.
D. Automatically reducing the number of clusters is part of the auto-scaling feature for multi-cluster warehouses.
1. Snowflake Documentation. (n.d.). Virtual Warehouse Considerations. In "Working with Warehouses". Retrieved from https://docs.snowflake.com/en/user-guide/warehouses-considerations. See section "Warehouse Suspension and Resumption".
2. Snowflake Documentation. (n.d.). CREATE WAREHOUSE. In "SQL Command Reference". Retrieved from https://docs.snowflake.com/en/sql-reference/sql/create-warehouse. See description for the AUTOSUSPEND parameter.
Keep practicing
Take the free SOL-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SOL-C01 practice questions
- Question 1Which Snowflake object is a logical container for schemas and other database objects?
- Question 2How can Python variable substitution be performed in Snowflake notebooks?
- Question 3Which SQL command is commonly used to load structured data from a stage into a Snowflake …
- Question 4Which command can be used to query the Information Schema in Snowflake to retrieve a list…
- Question 5Which command is synonymous with the LIST command in Snowflake?
- Question 6Which of the following data format supported to unload semi-structured data from Snowflak…
