Question

A data engineering team on Snowflake Standard Edition is experiencing query queuing during peak business hours because dozens of BI users hit the same virtual warehouse concurrently. An architect proposes configuring the warehouse as a multi-cluster warehouse with a minimum of 1 and maximum of 4 clusters to handle the concurrency. What must the team do to implement this recommendation?

Accepted Answer

Upgrade to at least Enterprise Edition, because multi-cluster warehouses are not available on Standard Edition

Answer

Nothing extra — multi-cluster warehouses are available on all editions including Standard, so they can configure the min/max clusters immediately

Answer

Scale the warehouse up to a larger size (e.g., X-Large), since scaling up is the only concurrency solution offered on Standard Edition

Answer

Upgrade to Business Critical Edition, because concurrency scaling requires the enhanced security tier