Snowflake
COF-R02 · Question #100
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…
The correct answer is A. Use multi-clustered warehousing to scale out warehouse capacity. D. Migrate some queries to a new warehouse to reduce load. See the full explanation below for the reasoning.
Question
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).
Options
- AUse multi-clustered warehousing to scale out warehouse capacity.
- BScale up the warehouse size to allow Queries to execute faster.
- CStop and start the warehouse to clear the queued queries
- DMigrate some queries to a new warehouse to reduce load
- ELimit user access to the warehouse so fewer queries are run against it.
How the community answered
(20 responses)- A75% (15)
- B15% (3)
- C10% (2)
Community Discussion
No community discussion yet for this question.