SnowPro Advanced: Data Engineer — Question 68

A Data Engineer is querying a large table (+100 million rows) with the following SQL:

select name
, address
, datediff(year, birthdate, current_date())
from customers;

The Engineer notices that the results cache is not being used on subsequent executions of the query. The underlying table does not change and the data is not updated in between query executions.

What is causing this to occur?

Answer options

• A. Calculations are not stored in the results cache.
• B. Large results are not stored in the results cache.
• C. Date functions are not stored in the results cache.
• D. Non-deterministic calculations are not stored in the results cache.

Correct answer: D

Explanation

The correct answer is D because non-deterministic calculations can produce different results on each execution, which prevents them from being cached. Options A, B, and C are incorrect as they pertain to specific types of calculations or results that do not inherently affect the caching behavior in this scenario.