ARA-C01 Snowflake Architecture Practice Question
A Snowflake architect is designing a multi-cluster warehouse to handle varying concurrency demands for a BI dashboard that experiences peak usage during business hours. The architect wants to ensure that queries are not queued and that the warehouse scales out automatically. Which configuration should the architect use?
⚠ Common exam trap
The trap here is assuming that a larger warehouse size solves concurrency issues, when actually multi-cluster scaling is needed to handle multiple concurrent queries.
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
✓
Set the warehouse to multi-cluster mode with scaling policy set to STANDARD.
To prevent queuing during peak concurrency, a multi-cluster warehouse with the STANDARD scaling policy is optimal. The STANDARD policy adds clusters immediately when queries are queued, ensuring low latency. ECONOMY may delay scaling, and single-cluster or fixed cluster count configurations cannot scale out dynamically.
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 the warehouse to multi-cluster mode with a minimum cluster count of 1 and maximum cluster count of 1.
Why it's wrong here
Setting minimum and maximum cluster counts to 1 effectively disables multi-cluster scaling, as the warehouse cannot add more clusters. This configuration behaves like a single-cluster warehouse and will not scale out to handle increased concurrency, leading to queuing.
- ✓
Set the warehouse to multi-cluster mode with scaling policy set to STANDARD.
Why this is correct
The STANDARD scaling policy starts additional clusters immediately when queries are queued, minimizing wait times. It is designed for high concurrency and ensures that queries are not queued by scaling out proactively. This meets the requirement of automatic scaling without queuing during peak usage.
- ✗
Set the warehouse to single-cluster mode with a larger warehouse size.
Why it's wrong here
Increasing warehouse size scales up compute power for individual queries but does not address concurrency; multiple concurrent queries may still queue. Multi-cluster scaling is required to handle varying concurrency by adding clusters. A single-cluster warehouse, regardless of size, has a fixed concurrency limit.
- ✗
Set the warehouse to multi-cluster mode with scaling policy set to ECONOMY.
Why it's wrong here
The ECONOMY scaling policy conserves credits by starting additional clusters only when the system estimates that queuing will occur, but it may not scale out quickly enough to prevent queuing during sudden spikes. For ensuring no queuing, a more aggressive policy like STANDARD is preferable.
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.