COF-C03 Practice Question: Performance Optimization, Querying, and Transformation
Which Snowflake feature allows a user to retrieve the results of a query that was executed 10 minutes ago without consuming additional virtual warehouse credits?
⚠ Common exam trap
Test-takers frequently mistake time travel for the result set cache, confusing historical data querying with the zero-cost caching of identical recent 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
✓
Result Set Cache
The Result Set Cache stores the results of queries for 24 hours. If the same query is executed again, the underlying data has not changed, and the query meets certain criteria, Snowflake returns the result directly from the cache. This bypasses the virtual warehouse, resulting in faster response times and zero compute cost.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Metadata Cache
Why it's wrong here
The Metadata Cache stores statistics about micro-partitions, such as row counts and min/max values. It helps the optimizer prune data during query planning but does not store the actual result sets of previous queries, meaning a warehouse is still required to process the data.
- ✗
Virtual Warehouse Local Cache
Why it's wrong here
Local cache (SSD) stores raw data from micro-partitions recently accessed by the warehouse. While it speeds up subsequent queries by avoiding remote storage reads, it still requires an active, running virtual warehouse to process the data and compute the query results.
- ✓
Result Set Cache
Why this is correct
Result Set Cache is a global cache that persists query results for 24 hours. When a query is repeated and the data is unchanged, Snowflake retrieves the result directly from this cache without starting or utilizing a virtual warehouse, effectively making the query execution free of charge.
- ✗
Search Optimization Service
Why it's wrong here
The Search Optimization Service is a background process that speeds up point lookup queries by creating specialized data structures. It is used to accelerate the execution of new queries rather than retrieving pre-calculated results from previous executions, and it requires active compute resources.
About these practice questions
This COF-C03 question is part of Courseiva's 280-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.