Auto-suspend and auto-resume are enabled by default.

• A. No
• B. Sometimes
• C. Never
• D. Yes

Answer: (D)

In Snowflake, virtual warehouses can automatically shut down when idle and start up again when work arrives, helping manage compute costs while keeping response times smooth. Both features are enabled by default, so a warehouse will suspend after a period of inactivity (the default idle delay is 10 minutes) and will automatically resume when a new query comes in. This means the statement is true: you don’t have to manually suspend or resume for normal operation, and you only incur compute when you’re actually using the warehouse. You can adjust these defaults per warehouse if you need different behavior, but out of the box auto-suspend and auto-resume are turned on.