SnowPro Core Certification — Question 1288

What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?

Answer options

• A. Scale-up by resizing the warehouse.
• B. Scale-out with a multi-cluster warehouse.
• C. Disable auto-suspend on the warehouse.
• D. Enable auto-resume on the warehouse.

Correct answer: B

Explanation

The correct answer is B, as scaling out with a multi-cluster warehouse allows for handling more concurrent queries by distributing the workload across multiple clusters. Option A would only increase the power of a single warehouse, while C and D are related to the warehouse's suspension and resumption behavior, which does not address the queuing of queries.