SnowflakeSnowflake
COF-C02 · Question #675
COF-C02 Question #675: Real Exam Question with Answer & Explanation
The correct answer is C: If the referenced data in the table has changed. The query results cache can be used as long as the data in the table has not changed since the last time the query was run. If the underlying data has changed, Snowflake will not use the cached results and will re-execute the query.
Performance Concepts
Question
What affects whether the query results cache can be used?
Options
- AIf the query contains a deterministic function
- BIf the virtual warehouse has been suspended
- CIf the referenced data in the table has changed
- DIf multiple users are using the same virtual warehouse
Explanation
The query results cache can be used as long as the data in the table has not changed since the last time the query was run. If the underlying data has changed, Snowflake will not use the cached results and will re-execute the query.
Topics
#Query Caching#Result Cache#Performance Optimization#Data Freshness
Community Discussion
No community discussion yet for this question.