SnowPro Core Certification — Question 188

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of queries is always queuing in the warehouse.

According to recommended best practice, what should be done to reduce the queue volume? (Choose two.)

Answer options

• A. Use multi-clustered warehousing to scale out warehouse capacity.
• B. Scale up the warehouse size to allow queries to execute faster.
• C. Stop and start the warehouse to clear the queued queries.
• D. Migrate some queries to a new warehouse to reduce load.
• E. Limit user access to the warehouse so fewer queries are run against it.

Correct answer: A, D

Explanation

Using multi-clustered warehousing (option A) allows for scaling out and managing higher query volumes effectively, while migrating some queries to a new warehouse (option D) helps distribute the load. Options B and C do not address the fundamental issue of query queuing, and E may not be a feasible solution without impacting user access.