DEA-C02 · Question #96
DEA-C02 Question #96: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #96. The question stem and answer options stay visible for context.
Question
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?
Options
- ACalculations are not stored in the results cache.
- BLarge results are not stored in the results cache.
- CDate functions are not stored in the results cache.
- DNon-deterministic calculations are not stored in the results cache.
Unlock DEA-C02 to see the answer
You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.