What is the default multi-cluster warehouse scaling policy?

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 multi-cluster warehouse scaling policy?

Explanation:
Scaling policy for a multi-cluster warehouse dictates how Snowflake adds or removes compute clusters to handle concurrent queries. Standard Scaling is the default approach, providing a balanced method: as demand rises, Snowflake adds clusters to maintain performance, and as demand falls, it scales them back, aiming for steady responsiveness without being overly aggressive on cost. This default ensures reliable performance for concurrent workloads without the more aggressive cost-saving behavior of other policies. Economy Scaling exists as an option that favors lower cost by scaling down more aggressively, but it can introduce latency when new work arrives. Auto-Suspend is a separate setting that suspends a warehouse after inactivity, not a scaling policy. Maximized Scaling isn’t a standard option. So the default multi-cluster scaling policy is Standard Scaling.

Scaling policy for a multi-cluster warehouse dictates how Snowflake adds or removes compute clusters to handle concurrent queries. Standard Scaling is the default approach, providing a balanced method: as demand rises, Snowflake adds clusters to maintain performance, and as demand falls, it scales them back, aiming for steady responsiveness without being overly aggressive on cost. This default ensures reliable performance for concurrent workloads without the more aggressive cost-saving behavior of other policies. Economy Scaling exists as an option that favors lower cost by scaling down more aggressively, but it can introduce latency when new work arrives. Auto-Suspend is a separate setting that suspends a warehouse after inactivity, not a scaling policy. Maximized Scaling isn’t a standard option. So the default multi-cluster scaling policy is Standard Scaling.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy