COF-C03 Practice Question: Snowflake AI Data Cloud Features and Architecture
Exhibit
ALTER WAREHOUSE ANALYTICS_WH SET MAX_CLUSTER_COUNT = 4, MIN_CLUSTER_COUNT = 1, SCALING_POLICY = 'ECONOMY', AUTO_SUSPEND = 60;
Refer to the exhibit. Based on the configuration provided for the ANALYTICS_WH, how will Snowflake manage clusters when multiple users start submitting queries at the same time?
⚠ Common exam trap
Candidates often assume all scaling policies behave the same regarding cluster startup. They fail to realize that the 'Economy' policy is specifically designed to delay cluster startup to save money.
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
✓
Snowflake will start a new cluster only if it estimates there is enough work for 6 minutes.
The Economy scaling policy prioritizes cost savings by waiting to start a new cluster until there is enough work to keep it busy for at least six minutes. This is different from the Standard policy, which starts clusters immediately to minimize queuing. This configuration is ideal for workloads where immediate response times are less critical than budget control.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A new cluster will start immediately as soon as a single query is queued.
Why it's wrong here
This behavior describes the Standard scaling policy, which focuses on minimizing latency for users. Under the Economy policy, Snowflake monitors the estimated load and only spins up a new cluster if it determines the cluster will be fully utilized for several minutes. This prevents frequent, short-lived cluster activations that increase costs.
- ✓
Snowflake will start a new cluster only if it estimates there is enough work for 6 minutes.
Why this is correct
The Economy scaling policy is designed to conserve credits by ensuring that secondary clusters are only initiated when the system anticipates a sustained workload. Specifically, it waits until it detects sufficient queued queries to keep an additional cluster busy for at least six minutes, effectively balancing performance with financial efficiency.
- ✗
The warehouse will immediately scale up to 4 clusters to handle the incoming load.
Why it's wrong here
Snowflake scales out incrementally, adding one cluster at a time based on the scaling policy and the actual demand. It would never jump directly to the maximum cluster count unless the queued workload was massive and the scaling policy allowed for it. The Economy policy further restricts this rapid expansion to save money.
- ✗
The warehouse will automatically increase its size from X-Small to Large.
Why it's wrong here
Multi-cluster warehouses scale horizontally by adding clusters of the same size, not vertically by changing the size of the existing clusters. Changing the size of a warehouse (e.g., from Small to Medium) requires a separate command and is not part of the automatic scaling process managed by the Scaling Policy.
About these practice questions
One of 280 original COF-C03 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 COF-C03 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 COF-C03 exam.