Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 293

What actions will prevent leveraging of the ResultSet cache?

    Correct Answer: B

    Stopping the virtual warehouse that the query is running against will prevent leveraging of the ResultSet cache. This is because the virtual warehouse must be running and active to use the cache. Removing a column from the query SELECT list, the result not being reused within the last 12 hours, and executing the RESULTS_SCAN() table function do not directly prevent leveraging the ResultSet cache in the same way.

Discussion
Marge23Option: A

exactly maches previous query.

_yyuktaOption: A

A is correct

MultiCloudIronManOption: A

Correct

shyemkoOption: A

A is correct

EmiB

A & D both are correct

EmiB

Only A, sorry. D will force the use of Result Cache.

Yogesh1984

A & D both are correct