Question 25

Explanation

✅ Multi-cluster warehouse in AUTO_SCALE mode.

Explanation:

A multi-cluster warehouse in AUTO_SCALE mode is the best choice for workloads with unpredictable spikes in concurrency, such as end-of-month reporting and ad-hoc analyst queries. This configuration allows Snowflake to dynamically scale out by adding clusters when demand increases, ensuring efficient query execution without excessive resource allocation during idle periods.

❌ Why the other options are incorrect?

Single-cluster warehouse with AUTO_SUSPEND → Incorrect, because a single-cluster warehouse cannot scale out to handle high-concurrency spikes, leading to potential query queuing.

Multi-cluster warehouse in MAXIMIZED mode → Incorrect, as MAXIMIZED mode keeps all clusters active at all times, which is costly and unnecessary for workloads with sporadic spikes.

Snowpark-Optimized warehouse → Incorrect, because Snowpark-Optimized warehouses are designed for memory-intensive machine learning and data transformation workloads, not high-concurrency SQL queries.

Warehouse with Query Acceleration Service enabled → Incorrect, since Query Acceleration Service helps with large scans and complex queries, but does not directly address high-concurrency spikes.

For more details on multi-cluster warehouse configurations, you can check the official Snowflake documentation.