Auto-suspend in a multi-cluster warehouse occurs under what condition?

• A. When there is continuous activity
• B. When there is no activity for the specified period and at least the minimum number of clusters is running
• C. It never occurs
• D. Only during scheduled maintenance

Answer: (B)

Auto-suspend for a multi-cluster warehouse happens when the system is idle for the configured timeout, but it must leave at least the minimum number of clusters running. Snowflake keeps a baseline of min clusters so that there’s always some capacity ready to handle new queries, and if no activity occurs for the specified idle period, it scales down by suspending extra clusters while keeping those minimum clusters active. When new activity arrives, the warehouse can resume more clusters up to the maximum as needed. If there’s continuous activity, it won’t suspend; and maintenance windows aren’t the trigger for auto-suspend.