SnowPro Core Certification — Question 118

If auto-suspend is enabled for a Virtual Warehouse, the Warehouse is automatically suspended when:

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D because auto-suspend is designed to trigger when the Warehouse is not in use for a predetermined duration. Options A and B do not accurately describe the conditions for suspension, as terminating sessions or completing the last query does not necessarily lead to auto-suspension. Option C is irrelevant, as user login status does not affect the auto-suspend feature.