What is the default scaling policy for multi-cluster warehouses?

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

Multiple Choice

What is the default scaling policy for multi-cluster warehouses?

Explanation:
When a multi-cluster warehouse handles many users or heavy workloads, the scaling policy determines how many clusters Snowflake starts and stops to meet that demand. The default setting is Standard, which offers a balanced approach: it adds clusters as needed for higher concurrency but avoids keeping many clusters running all the time, helping manage costs. If you want automatic growth and shrinking in response to load, you can enable Auto-scale, which adjusts cluster counts within your defined min and max. Other policies lean toward more aggressive cost savings (Economy) or maximum performance (Maximized) and aren’t the default.

When a multi-cluster warehouse handles many users or heavy workloads, the scaling policy determines how many clusters Snowflake starts and stops to meet that demand. The default setting is Standard, which offers a balanced approach: it adds clusters as needed for higher concurrency but avoids keeping many clusters running all the time, helping manage costs. If you want automatic growth and shrinking in response to load, you can enable Auto-scale, which adjusts cluster counts within your defined min and max. Other policies lean toward more aggressive cost savings (Economy) or maximum performance (Maximized) and aren’t the default.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy