Answer-first summary for fast verification
Answer: The user has the appropriate privileges on the objects associated with the query., The query has been run within 24 hours of the previously-run query.
The correct answers are A and E. According to Snowflake documentation on querying persisted results, the results cache can return cached query results when: (A) the user has appropriate privileges on the objects associated with the query, and (E) the query has been run within 24 hours of the previously-run query. The community discussion strongly supports AE with 89% consensus and references to official documentation. Option B is incorrect because reclustering micro-partitions would invalidate the cache. Option C is incorrect because the result cache operates at the cloud services layer, independent of the virtual warehouse used. Option D is incorrect because User Defined Functions (UDFs) typically prevent result caching due to their dynamic nature.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which of the following conditions must be met to return a query result from the Snowflake results cache? (Choose two.)
A
The user has the appropriate privileges on the objects associated with the query.
B
Micro-partitions have been reclustered since the query was last run.
C
The new query is run using the same virtual warehouse as the previous query.
D
The query includes a User Defined Function (UDF).
E
The query has been run within 24 hours of the previously-run query.