Snowflake
COF-R02 · Question #230
COF-R02 Question #230: Real Exam Question with Answer & Explanation
Sign in or unlock COF-R02 to reveal the answer and full explanation for question #230. The question stem and answer options stay visible for context.
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
Unlock COF-R02 to see the answer
You've previewed enough free COF-R02 questions. Unlock COF-R02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.