COF-C03 Practice Question: Snowflake AI Data Cloud Features and Architecture
An administrator is configuring a virtual warehouse for a data science team that runs unpredictable, long-running training queries. The team wants the warehouse to shut down automatically when idle to save credits, but they also want queries to start immediately when a new request arrives without waiting for a manual resume. Which configuration should the administrator apply?
⚠ Common exam trap
The trap here is believing that disabling auto-resume gives more control, when in fact it forces manual intervention and delays query start.
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 auto-suspend after a short idle period and rely on auto-resume to start it when a query is submitted.
Auto-suspend stops a virtual warehouse after a defined idle period, preventing credit usage when no queries are running. Auto-resume, which is enabled by default, automatically starts the warehouse when a new query is submitted. Together they deliver the desired behavior: the warehouse shuts down when idle and starts immediately on demand, with no manual resume step.
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 auto-suspend and enable multi-cluster scaling to ensure queries start immediately.
Why it's wrong here
Multi-cluster scaling addresses concurrency by adding clusters when many queries run simultaneously; it does not control whether a suspended warehouse resumes automatically. A suspended warehouse still requires auto-resume to start, so adding multi-cluster mode does not satisfy the immediate-start requirement and may add unnecessary configuration complexity.
- ✗
Configure the warehouse to auto-suspend and disable auto-resume so the team controls when the warehouse starts.
Why it's wrong here
Disabling auto-resume means the warehouse stays suspended until a user with the appropriate privilege manually resumes it. That would force the team to wait for a manual action before queries can run, directly conflicting with the requirement that queries start immediately when submitted. Auto-suspend alone without auto-resume does not meet the scenario.
- ✗
Leave the warehouse running permanently and rely on the Query Result Cache to reduce credit consumption.
Why it's wrong here
Keeping the warehouse running continuously consumes credits even when idle, which contradicts the goal of saving credits during inactivity. The Query Result Cache only helps when identical queries are reissued against unchanged data; it does not offset the cost of an always-on warehouse, so this configuration fails the requirement to suspend when idle.
- ✓
Set the warehouse to auto-suspend after a short idle period and rely on auto-resume to start it when a query is submitted.
Why this is correct
Auto-suspend stops the warehouse after the specified idle period, eliminating credit consumption while no queries run. Auto-resume is enabled by default and starts the warehouse automatically when a new query arrives, so the team gets both cost savings and immediate query start without manual intervention. This combination directly satisfies the stated requirements.
About these practice questions
Courseiva writes every COF-C03 question from scratch — 280 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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.