SOL-C01 · Question #111
SOL-C01 Question #111: Real Exam Question with Answer & Explanation
The correct answer is E: The query will complete successfully, and the warehouse will remain active for another 5 minutes. The auto-suspend timer is reset each time the warehouse is used. Since the query takes 7 minutes, the warehouse is active during that time. After the query completes, the 5-minute auto- suspend timer starts. Therefore, the warehouse will remain active for another 5 minutes before
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
Explanation
The auto-suspend timer is reset each time the warehouse is used. Since the query takes 7 minutes, the warehouse is active during that time. After the query completes, the 5-minute auto- suspend timer starts. Therefore, the warehouse will remain active for another 5 minutes before auto-suspending.
Topics
Community Discussion
No community discussion yet for this question.