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…

Question

Options

• AUse multi-clustered warehousing to scale out warehouse capacity: This approach allows for
• BScale up the warehouse size to allow Queries to execute faster: Increasing the size of the
• 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.

• A
  83% (20)
• C
  4% (1)
• D
  4% (1)
• E
  8% (2)

Explanation

Snowflake best practices recommend two approaches for persistent queuing: (A) use multi-cluster warehousing to scale out - adding more clusters means more queries can run concurrently rather than waiting in queue; and (B) scale up the warehouse size - larger warehouses complete individual queries faster, which frees slots for queued queries more quickly. Option C (stop/start) does not resolve the root cause and disrupts active workloads. Option D (migrating queries to a new warehouse) is a valid architectural approach but is not a Snowflake-recommended best practice specifically for queue reduction. Option E (limiting access) reduces load by blocking users, which is not a performance optimization.

No community discussion yet for this question.