Snowflake
COF-R02 · Question #230
When should a multi-cluster warehouse be used in auto-scaling mode?
The correct answer is D. When a large number of concurrent queries are run on the same warehouse. See the full explanation below for the reasoning.
Question
When should a multi-cluster warehouse be used in auto-scaling mode?
Options
- AWhen it is unknown how much compute power is needed
- BIf the select statement contains a large number of temporary tables or Common Table Expressions
- CIf the runtime of the executed query is very slow
- DWhen a large number of concurrent queries are run on the same warehouse
How the community answered
(26 responses)- A4% (1)
- B12% (3)
- C4% (1)
- D81% (21)
Community Discussion
No community discussion yet for this question.