SnowPro Core Certification — Question 307

Which of the following conditions must be met in order to return results from the results cache? (Choose two.)

Answer options

• 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.

Correct answer: A, E

Explanation

The correct answers are A and E because a user must have the proper privileges on the relevant objects to access the cached results, and the query must have been executed within 24 hours to ensure the cache remains valid. Options B, C, and D do not affect the results cache's ability to return results, making them incorrect.