Question

A data engineering team runs a customer-facing dashboard that experiences a large, sustained burst of concurrent queries every morning between 8:00 AM and 9:00 AM. During this window, response times must remain consistently fast, and the team is willing to pay for maximum performance rather than optimize for cost. They configure a multi-cluster warehouse with MIN_CLUSTER_COUNT = 3 and MAX_CLUSTER_COUNT = 3. How will this warehouse behave?

Accepted Answer

It runs in Maximized mode, always keeping all 3 clusters running while the warehouse is active, providing consistent capacity for concurrent queries.

Answer

It runs in Auto-scale mode, starting with 1 cluster and adding clusters up to 3 only when query queuing occurs.

Answer

It scales up to a larger warehouse size automatically when concurrency increases beyond what 3 clusters can handle.

Answer

It suspends 2 of the 3 clusters during idle periods and resumes them only when the first query arrives.