Snowflake SnowPro Advanced: Data Engineer Certification Exam DEA-C01 Question # 13 Topic 2 Discussion

Snowflake SnowPro Advanced: Data Engineer Certification Exam DEA-C01 Question # 13 Topic 2 Discussion

DEA-C01 Exam Topic 2 Question 13 Discussion:
Question #: 13
Topic #: 2

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:

DEA-C01 Question 13

The underlying table does not change between executions

What are the results of both runs?


A.

The first and second run returned the same results because sample is deterministic


B.

The first and second run returned the same results, because the specific SEEDvalue was provided.


C.

The first and second run returned different results because the query is evaluated each time it is run.


D.

The first and second run returned differentresults because the query uses *instead of an explicit column list


Get Premium DEA-C01 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.