SnowPro Core Certification — Question 492

What actions will prevent leveraging of the ResultSet cache?

Answer options

• 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

Correct answer: A

Explanation

Option A is correct because removing a column from the SELECT list directly alters the query, preventing the use of the cached result. The other options do not necessarily impact the caching mechanism: stopping the virtual warehouse (B) or the timing of result reuse (C) won't invalidate the cache, and executing RESULTS_SCAN() (D) is intended to utilize cached results.