Snowflake multi-cluster warehouses are designed to address fluctuating query concurrency by adding and removing compute clusters according to workload demand.
Option D creates a Medium-sized warehouse with a maximum of ten clusters and the STANDARD scaling policy. Because MIN_CLUSTER_COUNT is not explicitly specified, Snowflake uses its default value of one.
The resulting configuration operates in auto-scale mode, allowing Snowflake to increase the number of running clusters when concurrency rises and decrease it when demand subsides.
AUTO_SUSPEND=600 configures the warehouse to suspend after approximately ten minutes of inactivity. AUTO_RESUME=TRUE allows Snowflake to restart it automatically when eligible queries arrive.
Option A provides automatic suspension and resumption but creates only a single-cluster warehouse.
Option B configures multiple clusters but disables automatic resumption and assigns an unnecessarily large cluster size.
Option C also uses a large single-cluster configuration without horizontal concurrency scaling.
Therefore, D most closely meets the requirements.
Technical qualification: Multi-cluster warehouses require Enterprise Edition or higher. Additionally, STANDARD scaling prioritizes reducing query queues, while ECONOMY scaling more aggressively conserves credits. Therefore, D is the best available answer, but it is not necessarily the minimum-cost configuration for every workload.
Official Snowflake references: Multi-cluster Warehouses; CREATE WAREHOUSE; Warehouse Considerations.
Submit