Snowflake
SOL-C01 · Question #111
You have a Snowflake virtual warehouse named 'XSMALL WI-4' configured to auto-suspend after 5 minutes of inactivity. You execute a complex query that takes 7 minutes to complete. What will happen to t
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #111. The question stem and answer options stay visible for context.
Virtual Warehouses
Question
You have a Snowflake virtual warehouse named 'XSMALL WI-4' configured to auto-suspend after 5 minutes of inactivity. You execute a complex query that takes 7 minutes to complete. What will happen to the query's execution and the virtual warehouse?
Options
- AThe query will complete successfully, and the warehouse will remain active until manually
- BThe query will be terminated after 5 minutes, and the warehouse will be suspended.
- CThe query will complete successfully, and the warehouse will be suspended 5 minutes after the
- DThe query will complete successfully, and the warehouse will be suspended immediately after the
- EThe query will complete successfully, and the warehouse will remain active for another 5 minutes
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Warehouse auto-suspend#Inactivity timer#Query execution#Warehouse lifecycle