In Maximized mode, decreasing the max and min for a running cluster results in the specified number of warehouses shutting down after they finish executing statements and the auto-suspend period elapses.

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

In Maximized mode, decreasing the max and min for a running cluster results in the specified number of warehouses shutting down after they finish executing statements and the auto-suspend period elapses.

Explanation:
In a multi-cluster warehouse, the min and max settings define how many clusters can be kept active to handle concurrent work. When you lower these bounds while the warehouse is running, Snowflake scales its compute down to the new limits. It does this by gracefully terminating the extra clusters after they finish any statements they are currently processing, and then, if there’s no more work and the auto-suspend period passes, the remaining clusters are suspended to match the new configuration. So the specified number of clusters will shut down in accordance with the new min and max, even if there are no immediate new queries. This behavior isn’t tied to pending queries alone, and it isn’t correct to say they are never shut down automatically.

In a multi-cluster warehouse, the min and max settings define how many clusters can be kept active to handle concurrent work. When you lower these bounds while the warehouse is running, Snowflake scales its compute down to the new limits. It does this by gracefully terminating the extra clusters after they finish any statements they are currently processing, and then, if there’s no more work and the auto-suspend period passes, the remaining clusters are suspended to match the new configuration. So the specified number of clusters will shut down in accordance with the new min and max, even if there are no immediate new queries. This behavior isn’t tied to pending queries alone, and it isn’t correct to say they are never shut down automatically.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy