When should a multi-cluster virtual warehouse be used in Snowflake?

Question

Options

• AWhen queuing is delaying query execution on the warehouse
• BWhen there is significant disk spilling shown on the Query Profile
• CWhen dynamic vertical scaling is being used in the warehouse
• DWhen there are no concurrent queries running on the warehouse

• A
  93% (56)
• B
  3% (2)
• C
  2% (1)
• D
  2% (1)

Explanation

Multi-cluster warehouses address concurrency - when many users or queries compete for the same warehouse simultaneously, queries queue up and wait. Adding clusters allows Snowflake to route queued queries to additional compute clusters, reducing wait times. Disk spilling (option B) is a memory pressure issue solved by increasing warehouse size (scaling up), not adding clusters. Dynamic vertical scaling (option C) is about resizing, which is a different concept. And multi-cluster makes no sense when there are no concurrent queries (option D), as it would add unnecessary cost.

No community discussion yet for this question.