COF-C03 Practice Question: Snowflake AI Data Cloud Features and Architecture
Exhibit
{
"statement": "SELECT * FROM sales;",
"warehouse_state": "SUSPENDED",
"result_cache": "AVAILABLE"
}Refer to the exhibit. Given the state described in the JSON, what happens when a user executes the query?
⚠ Common exam trap
Candidates often believe that a suspended warehouse prevents any query execution, failing to realize that the Cloud Services layer can serve cached results without activating the compute cluster.
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
✓
The query returns results from the cache.
Even though the warehouse is suspended, the query will execute successfully because the Cloud Services layer can fulfill the request from the result cache. This highlights the efficiency of the Snowflake architecture, where the Cloud Services layer functions independently of the compute layer. If the query result exists in the cache and the underlying table data has not changed, Snowflake retrieves the result without starting the warehouse, saving costs.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The warehouse automatically resumes.
Why it's wrong here
The warehouse does not need to resume because the result is served directly from the result cache. Resuming the warehouse would incur unnecessary compute costs. Snowflake optimizes the process by checking the cache first, ensuring that compute resources are only utilized when absolutely necessary for data processing.
- ✗
The query fails due to lack of compute.
Why it's wrong here
Queries do not require an active warehouse to retrieve results if the data is available in the result cache. The Cloud Services layer manages this cache and returns the data immediately. This allows users to access historical results even if the warehouse is suspended, improving overall user accessibility.
- ✓
The query returns results from the cache.
Why this is correct
Since the result cache is available and the query is identical, the Cloud Services layer returns the cached result. This avoids the overhead of starting a virtual warehouse, resulting in fast query execution times and zero credit usage, which is an optimal use of Snowflake's metadata-driven architecture.
- ✗
The query waits for the warehouse to start.
Why it's wrong here
The query does not wait because it does not require compute resources to retrieve data from the cache. Waiting for a warehouse startup is only necessary when a new query execution requires processing that cannot be fulfilled by the result cache or metadata pruning, which is not the case here.
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.