How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''

The correct answer is D. Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT. A multi-cluster virtual warehouse operates in two modes: Maximized and Auto-scale. Maximized mode means all clusters run continuously regardless of workload - this is achieved by setting MIN_CLUSTER_COUNT equal to MAX_CLUSTER_COUNT (e.g., both set to 3). Auto-scale mode…

Performance Management

Question

Options

ASet the WAREHOUSES_SIZE to 6XL.
BSet the STATEMENT_TIMEOUT_1M_SECOMES to 0.
CSet the MAX_CONCURRENCY_LEVEL to a value of 12 or large.
DSet the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

How the community answered

(47 responses)

A
9% (4)
B
17% (8)
C
4% (2)
D
70% (33)

Explanation

A multi-cluster virtual warehouse operates in two modes: Maximized and Auto-scale. Maximized mode means all clusters run continuously regardless of workload - this is achieved by setting MIN_CLUSTER_COUNT equal to MAX_CLUSTER_COUNT (e.g., both set to 3). Auto-scale mode dynamically adds or removes clusters based on demand, which requires MIN and MAX to be different values. The other options are not related to cluster mode: WAREHOUSE_SIZE controls compute per cluster, STATEMENT_TIMEOUT controls query duration, and MAX_CONCURRENCY_LEVEL controls query queuing thresholds.

Topics

#Virtual Warehouses#Multi-cluster Warehouses#Warehouse Scaling#Performance Configuration

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice