Snowflake
ADA-C01 · Question #52
ADA-C01 Question #52: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #52. The question stem and answer options stay visible for context.
Question
A Snowflake Administrator is investigating why a query is not re-using the persisted result cache. The Administrator found the two relevant queries from the SNOWFLAKE. ACCOUNT_USAGE. QUERY_HISTORY view: Why is the second query re-scanning micro-partitions instead of using the first query's persisted result cache?
Options
- AThe second query includes a CURRENT_TIMESTAMP () function.
- BThe second query includes a CURRENT_DATE () function.
- CThe queries are executed with two different virtual warehouses.
- DThe queries are executed with two different roles.
Unlock ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-C01 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.