According to recomm...
 
Notifications
Clear all

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

1 Posts
1 Users
0 Likes
188 Views
(@rippesteban)
Posts: 727
Noble Member
Topic starter
 

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.

Show Answer Hide Answer

Suggested Answer: A,D
 
Posted : 30/11/2022 7:39 pm

Latest Snowflake COF-C02 Dumps Valid Version

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Share: