SnowflakeSnowflake
DEA-C02 · Question #3
DEA-C02 Question #3: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #3. The question stem and answer options stay visible for context.
Performance Optimization
Question
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.)
Options
- AThe results must be reused within 72 hours.
- BThe query must be executed using the same virtual warehouse.
- CThe USED_CACHED_RESULT parameter must be included in the query.
- DThe table structure contributing to the query result cannot have changed.
- EThe new query must have the same syntax as the previously executed query.
- FThe micro-partitions cannot have changed due to changes to other data in the table.
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.
Topics
#Snowflake Caching#Query Performance#Result Cache#Micro-partitions