What is the purpose of multi-cluster virtual warehouses?

Question

Options

• ATo create separate data warehouses to increase query optimization
• BTo allow users the ability to choose the type of compute nodes that make up a virtual warehouse
• CTo eliminate or reduce Queuing of concurrent queries
• DTo allow the warehouse to resize automatically

• A
  7% (2)
• C
  90% (26)
• D
  3% (1)

Explanation

Multi-cluster virtual warehouses are designed to handle high concurrency by automatically spinning up additional clusters when the number of queued queries exceeds capacity, and scaling back down when demand decreases. This eliminates or reduces query queuing for concurrent workloads. Option A is wrong because multi-cluster warehouses do not create separate data warehouses for optimization purposes. Option B is wrong because Snowflake does not expose the underlying compute node types to users. Option D describes auto-suspend/auto-resume or warehouse resizing (scaling up/down the size of a warehouse), which is different from multi-cluster (scaling out).

No community discussion yet for this question.