SnowPro Core Certification — Question 446

What is the purpose of multi-cluster virtual warehouses?

Answer options

• 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

Correct answer: C

Explanation

The correct answer is C because multi-cluster virtual warehouses are designed to handle multiple concurrent queries without causing delays. Option A is incorrect as the primary focus is not on creating separate data warehouses. Option B is irrelevant to the main purpose, which is not about choosing compute nodes. Option D is also incorrect as automatic resizing is not the main function of multi-cluster virtual warehouses.