COF-C02 · Question #154
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
The correct answer is A. When the system has enough load for 2 minutes. In an auto-scaling multi-cluster virtual warehouse with the SCALING_POLICY set to ECONOMY, another cluster is started when the system has enough load for 2 minutes (A). This policy is designed to optimize the balance between performance and cost, starting additional clusters…
Question
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
Options
- AWhen the system has enough load for 2 minutes
- BWhen the system has enough load for 6 minutes
- CWhen the system has enough load for 8 minutes
- DWhen the system has enough load for 10 minutes
How the community answered
(54 responses)- A91% (49)
- B2% (1)
- C6% (3)
- D2% (1)
Explanation
In an auto-scaling multi-cluster virtual warehouse with the SCALING_POLICY set to ECONOMY, another cluster is started when the system has enough load for 2 minutes (A). This policy is designed to optimize the balance between performance and cost, starting additional clusters only when the sustained load justifies it.
Topics
Community Discussion
No community discussion yet for this question.