COF-C03 Practice Question: Snowflake AI Data Cloud Features and Architecture
A Snowflake account has a virtual warehouse that is configured with AUTO_SUSPEND = 60 seconds and AUTO_RESUME = TRUE. A user runs a query that takes 5 minutes to complete. After the query finishes, the warehouse remains idle for 2 minutes and then suspends. During the idle period, what charges apply?
⚠ Common exam trap
The trap here is thinking that idle warehouses do not incur charges, but Snowflake bills for running warehouses even when idle.
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
✓
Charges apply for the entire 2-minute idle period because the warehouse is still running.
Snowflake charges for a virtual warehouse based on the time it is running, regardless of whether it is actively processing queries. During the idle period before auto-suspension, the warehouse continues to consume credits. The AUTO_SUSPEND setting controls how long the warehouse remains running after the last query, but any time it is running, charges apply. Therefore, the entire idle period incurs charges until the warehouse suspends.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
No charges apply during the idle period because the warehouse is not processing queries.
Why it's wrong here
Snowflake charges for a warehouse as long as it is running, even if idle. The warehouse remains active during the idle period until it suspends, and credits are consumed for that time. The AUTO_SUSPEND setting determines how long the warehouse stays running after the last query, and charges accrue during that period.
- ✗
Charges apply only if the warehouse is resumed during the idle period.
Why it's wrong here
Resuming a warehouse incurs charges, but the idle period itself also incurs charges as long as the warehouse is running. The warehouse does not need to be resumed to incur charges; it is already running. Charges are based on the warehouse's running state, not on whether it is actively processing queries or being resumed.
- ✓
Charges apply for the entire 2-minute idle period because the warehouse is still running.
Why this is correct
Snowflake bills for the time a warehouse is running, including idle time before auto-suspension. With AUTO_SUSPEND set to 60 seconds, the warehouse suspends after 60 seconds of inactivity. However, the scenario states it remains idle for 2 minutes before suspending, which implies the auto-suspend setting is not taking effect as expected. Regardless, any time the warehouse is running, credits are consumed. So charges apply for the idle period until suspension.
- ✗
Charges apply only for the first 60 seconds of idle time, as per the AUTO_SUSPEND setting.
Why it's wrong here
The AUTO_SUSPEND setting specifies the period of inactivity after which the warehouse suspends. If it is set to 60 seconds, the warehouse should suspend after 60 seconds of idle time. However, the question states it remained idle for 2 minutes, suggesting either a misconfiguration or a delay. Even so, charges apply for the entire time the warehouse is running, not just the first 60 seconds. The setting does not limit charges to 60 seconds; it dictates when suspension occurs.
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.