
Answer-first summary for fast verification
Answer: Removing a column from the query SELECT list
The question asks which actions prevent leveraging the ResultSet cache in Snowflake. Option A (Removing a column from the query SELECT list) is correct because any change to the query text, including modifying the SELECT list, makes it a different query that cannot reuse the cached result. Option D (Executing the RESULTS_SCAN() table function) is incorrect as it actually forces the use of the Result Cache by retrieving results from a previous query. The community discussion shows strong consensus for A (100% of answers and multiple upvoted comments), with one comment clarifying that D does not prevent but rather enables cache usage. Options B and C are irrelevant: B affects warehouse operations but not cache logic, and C describes cache expiration, not an action that prevents usage.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which actions will prevent the use of the Result Scan cache?
A
Removing a column from the query SELECT list
B
Stopping the virtual warehouse that the query is running against
C
If the result has not been reused within the last 12 hours
D
Executing the RESULTS_SCAN() table function