COF-C02 practice question 20 of 35

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Full set: 778 questions
Answer options
A: True
B: False
Correct Answer:
T; R; U; E
Explanation

Snowflake maintains a query result cache. When a user submits a query that is identical to one that has been executed previously, and the underlying data in the tables has not changed, Snowflake can return the results directly from this cache. This operation retrieves data from the global services layer and does not require a virtual warehouse to be active, thereby saving compute credits.

Why Incorrect

This is a True/False question.

References

1. Snowflake Documentation: "Querying - Using the Result Cache". It explicitly states, "When a query is executed, the result is cached for a period of time. If the same query is re-executed within that period by the user, and the underlying table data has not changed, Snowflake returns the cached result. This can significantly reduce query time and compute cost because the query does not have to be re-processed and does not require a running warehouse."

2. Snowflake Documentation: "Understanding the Query Profile - Result". This section of the documentation describes the "Query result from cache" step, which indicates that the query was fulfilled by the result cache, bypassing warehouse execution.

Scroll to Top