According to recommended best practice, what should be done to reduce the Queue volume?

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

According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

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.

View Answer

Answer: A, B

Explanation:

To address a high volume of queries queuing in a warehouse, Snowflake recommends two best practices:

A. Use multi-clustered warehousing to scale out warehouse capacity: This approach allows for the distribution of queries across multiple clusters within a warehouse, effectively managing the load and reducing the queue volume.

B. Scale up the warehouse size to allow Queries to execute faster: Increasing the size of the warehouse provides more compute resources, which can reduce the time it takes for queries to execute and thus decrease the number of queries waiting in the queue.

These strategies help to optimize the performance of the warehouse by ensuring that resources are scaled appropriately to meet demand.

Reference: Snowflake Documentation on Multi-Cluster Warehousing SnowPro Core Certification best practices