Answer-first summary for fast verification
Answer: The Warehouse is inactive for a specified period of time.
The correct answer is D because auto-suspend in Snowflake is designed to automatically turn off a virtual warehouse after it has been idle for a specified period of time, as confirmed by the community discussion and Snowflake documentation. This helps optimize costs by stopping compute resources when not in use. Option A is incorrect because terminating all sessions is not the trigger for auto-suspend. Option B is incorrect as the completion of the last query alone does not suspend the warehouse; it must also remain idle. Option C is incorrect because user login status does not directly determine auto-suspend; it depends on warehouse activity.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
If auto-suspend is enabled for a virtual warehouse, when is the warehouse automatically suspended?
A
All Snowflakes sessions using the Warehouse are terminated.
B
The last query using the Warehouse completes.
C
There are no users logged into Snowflake.
D
The Warehouse is inactive for a specified period of time.
No comments yet.