Explanation:
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.
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.