COF-C02 · Question #664
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
The correct answer is A. True. Snowflake maintains a query result cache for up to 24 hours. If a user submits an identical query and the underlying data has not changed, Snowflake returns the cached result directly without re-executing the query. Because no computation occurs, no active virtual warehouse is…
Question
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
Options
- ATrue
- BFalse
How the community answered
(36 responses)- A92% (33)
- B8% (3)
Explanation
Snowflake maintains a query result cache for up to 24 hours. If a user submits an identical query and the underlying data has not changed, Snowflake returns the cached result directly without re-executing the query. Because no computation occurs, no active virtual warehouse is needed and no compute credits are consumed. This is one of Snowflake's key cost-saving mechanisms.
Topics
Community Discussion
No community discussion yet for this question.