COF-C02 Question #124: Real Exam Question with Answer & Explanation

The correct answer is D: When a large number of concurrent queries are run on the same warehouse. A multi-cluster warehouse should be used in auto-scaling mode when there is a need to handle a large number of concurrent queries. Auto-scaling allows Snowflake to automatically add or remove compute clusters to balance the load, ensuring that performance remains consistent durin

Performance Management

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

Explanation

A multi-cluster warehouse should be used in auto-scaling mode when there is a need to handle a large number of concurrent queries. Auto-scaling allows Snowflake to automatically add or remove compute clusters to balance the load, ensuring that performance remains consistent during varying levels of demand.

Topics

#Multi-cluster warehouse#Auto-scaling#Warehouse scaling#Concurrency management

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions