SnowPro Core Certification — Question 387

Several users are using the same virtual warehouse. The users report that the queries are running slowly, and that many queries are being queued.

What is the recommended way to resolve this issue?

Answer options

• A. Reduce the warehouse STATEMENT_QUEUED_TIMEOUT_IN SECONDS parameter.
• B. Reduce the warehouse AUTO_SUSPEND parameter.
• C. Increase the warehouse MAX_CONCURRENCY_LIMIT parameter.
• D. Increase the warehouse MAX_CLUSTER_COUNT parameter.

Correct answer: D

Explanation

Increasing the MAX_CLUSTER_COUNT parameter allows more clusters to handle the workload, thus accommodating more concurrent queries and reducing queuing. The other options either reduce timeout or limit concurrency, which does not help in alleviating the issue of slow queries and queuing.