SnowPro Advanced: Data Engineer — Question 126

A Data Engineer executes a complex query and wants to make use of Snowflake’s query results caching capabilities to reuse the results.
Which conditions must be met? (Choose three.)

Answer options

• A. The results must be reused within 72 hours.
• B. The query must be executed using the same virtual warehouse.
• C. The USED_CACHED_RESULT parameter must be included in the query.
• D. The table structure contributing to the query result cannot have changed.
• E. The new query must have the same syntax as the previously executed query.
• F. The micro-partitions cannot have changed due to changes to other data in the table.

Correct answer: D, E, F

Explanation

The correct answers are D, E, and F because they ensure that the conditions for using cached results are met: the table structure must be unchanged, the syntax of the new query should match the previous one, and the micro-partitions must remain the same. Options A, B, and C are incorrect as they do not pertain to the caching conditions required for result reuse.