SnowPro Core (COF-C03) · Free practice question 8 of 15
Query result cache
A user runs the exact same query twice in a row within one minute. The underlying tables have not changed and the warehouse is the same. The second run returns instantly and consumes no warehouse credits. Which Snowflake cache served the result?
- A.The metadata cache in the cloud services layer.
- B.The result cache in the cloud services layer.
- C.The local disk cache on the running warehouse cluster.
- D.The remote storage cache in cloud blob storage.
Show answer and explanation
Correct answer: B. The result cache in the cloud services layer.
Why: The result cache (cloud services layer) serves identical queries against unchanged tables for up to 24 hours without using warehouse credits. Local disk cache would still require a running warehouse and incur credit. The metadata cache stores object metadata, not result rows.
More free SnowPro Core (COF-C03) questions
- Micro-partition immutability
- SECURITYADMIN for user and role management
- Multi-cluster warehouses for concurrency
- Snowflake edition for extended Time Travel
- Recovering a truncated table with Time Travel
- Types of internal stages
- File sizing for COPY INTO
- Reader accounts for non-Snowflake consumers
- LATERAL FLATTEN on VARIANT arrays
- Streams and tasks for change data capture
- Clustering keys for partition pruning
- Network policies for IP allowlisting
- Zero-copy cloning for QA environments
- Snowpipe auto-ingest for low latency