Câu 49: SnowPro Advanced Data Engineer

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.CUSTOMERSAMPLE(10) SEED (99);The underlying table does not change between executions. What are the results of both runs?

1. A. The first and second run returned the same results, because SAMPLE is deterministic.
2. B. The first and second run returned the same results, because the specific SEED value was provided. — đáp án hiện tại
3. C. The first and second run returned different results, because the query is evaluated each time it is run.
4. D. The first and second run returned different results, because the query uses * instead of an explicit column list.