Answer-first summary for fast verification
Answer: To eliminate or reduce queuing of concurrent queries
The purpose of multi-cluster virtual warehouses in Snowflake is to eliminate or reduce queuing of concurrent queries. When a single virtual warehouse receives more queries than it can handle concurrently, queries are queued. Multi-cluster warehouses automatically scale out by adding additional clusters to handle the increased load, thus reducing or eliminating queuing. Option A is incorrect because multi-cluster warehouses don't create separate data warehouses; they scale within a single warehouse. Option B is incorrect because users don't choose compute node types; Snowflake manages the underlying infrastructure. Option D describes auto-scaling, which is related but specifically addresses resizing within a cluster rather than the multi-cluster functionality that prevents queuing.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is the purpose of a multi-cluster warehouse?
A
To create separate data warehouses to increase query optimization
B
To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
C
To eliminate or reduce queuing of concurrent queries
D
To allow the warehouse to resize automatically
No comments yet.