Snowflake

COF-R02 · Question #258

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

The correct answer is A. Removing a column from the query SELECT list D. Executing the RESULTS_SCAN() table function. See the full explanation below for the reasoning.

Question

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Options

ARemoving a column from the query SELECT list
BStopping the virtual warehouse that the query is running against
CClustering of the data used by the query
DExecuting the RESULTS_SCAN() table function
EChanging a column that is not in the cached query

How the community answered

(33 responses)

A
73% (24)
B
3% (1)
C
18% (6)
E
6% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full COF-R02 Practice