DEA-C02 · Question #52
DEA-C02 Question #52: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #52. The question stem and answer options stay visible for context.
Question
A Data Engineer enables a result cache at the session level with the following command: ALTER SESSION SET USE_CACHED_RESULT = TRUE; The Engineer then runs the following SELECT query twice without delay: SELECT * FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.CUSTOMER SAMPLE(10) SEED (99); The underlying table does not change between executions. What are the results of both runs?
Options
- AThe first and second run returned the same results, because SAMPLE is deterministic.
- BThe first and second run returned the same results, because the specific SEED value was
- CThe first and second run returned different results, because the query is evaluated each time it is
- DThe first and second run returned different results, because the query uses * instead of an explicit
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.