ARA-C01 Snowflake Architecture Practice Question
A data architect is designing a multi-cluster warehouse strategy. They require the warehouse to automatically scale up if queueing persists while maintaining cost efficiency during periods of low activity. Which configuration best addresses these requirements?
⚠ Common exam trap
Many test-takers confuse scaling up (increasing warehouse size for complex queries) with scaling out (adding clusters for concurrency), selecting the wrong setting to handle continuous ingestion queueing spikes.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Enable Auto-scale with MIN_CLUSTER_COUNT=1 and MAX_CLUSTER_COUNT=5, and set Auto-suspend to 60 seconds.
Configuring 'Multi-cluster' with 'Auto-scale' mode allows Snowflake to spin up additional clusters to handle concurrency, preventing queueing. Setting the 'Auto-suspend' parameter to a short duration ensures compute resources are released when idle, directly controlling costs. This combination is the architectural standard for balancing high-concurrency demand spikes with efficient resource utilization in dynamic environments where workloads fluctuate significantly throughout the business day.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Set MAX_CONCURRENCY_LEVEL to 1 and disable auto-suspend.
Why it's wrong here
Disabling auto-suspend prevents Snowflake from releasing resources, leading to unnecessary costs. Setting MAX_CONCURRENCY_LEVEL to 1 restricts the warehouse to executing only one query at a time, which effectively disables the benefits of multi-cluster scaling and severely limits throughput performance during peak usage periods.
- ✗
Set the warehouse to 'MAXIMIZED' mode with auto-suspend at 60 minutes.
Why it's wrong here
MAXIMIZED mode forces all clusters to run simultaneously, which ignores the dynamic nature of auto-scaling and leads to excessive compute costs. A 60-minute auto-suspend threshold is too long for most cost-sensitive environments, keeping compute active long after the workload has finished its execution phase.
- ✓
Enable Auto-scale with MIN_CLUSTER_COUNT=1 and MAX_CLUSTER_COUNT=5, and set Auto-suspend to 60 seconds.
Why this is correct
This configuration enables horizontal scaling to address queueing while ensuring idle clusters are terminated promptly. Using a short 60-second auto-suspend window minimizes costs by ensuring that expensive compute resources are not held during periods of inactivity, providing an optimized balance of performance and fiscal responsibility.
- ✗
Increase warehouse size to 4XL and disable multi-cluster scaling.
Why it's wrong here
Scaling vertically to a 4XL warehouse increases compute power for individual large queries but does not solve concurrency queueing issues. Relying on a single massive cluster is inefficient for high-concurrency workloads where smaller, parallel clusters are more effective at managing simultaneous requests without wasting capacity.
About these practice questions
One of 209 original ARA-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Snowflake exam blueprint
This ARA-C01 practice question is part of Courseiva's free Snowflake certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the ARA-C01 exam.