COF-C02 · Question #255
If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
The correct answer is A. Auto-scale mode. In Auto-scale mode, a multi-cluster virtual warehouse dynamically adds and removes compute clusters based on workload demand. When queries begin queuing, additional clusters are spun up to handle the load and shut down when demand drops. In contrast, Maximized mode runs all…
Question
If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
Options
- AAuto-scale mode
- BMaximized mode
- CEconomy scaling policy
- DStandard scaling policy
How the community answered
(48 responses)- A88% (42)
- B6% (3)
- C4% (2)
- D2% (1)
Explanation
In Auto-scale mode, a multi-cluster virtual warehouse dynamically adds and removes compute clusters based on workload demand. When queries begin queuing, additional clusters are spun up to handle the load and shut down when demand drops. In contrast, Maximized mode runs all clusters simultaneously at all times regardless of load. Economy and Standard are scaling policies that affect how aggressively clusters are added, but the mode that enables dynamic cluster addition at all is Auto-scale mode.
Topics
Community Discussion
No community discussion yet for this question.