SnowPro Core Certification — Question 393

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

Answer options

• A. Removing a column from the query SELECT list
• B. Stopping the virtual warehouse that the query is running against
• C. Clustering of the data used by the query
• D. Executing the RESULTS_SCAN() table function
• E. Changing a column that is not in the cached query

Correct answer: A, E

Explanation

Removing a column from the SELECT list (A) alters the query structure, preventing cache utilization. Similarly, changing a column that is not included in the cached query (E) also impacts the cache's effectiveness. The other options either do not affect the cache directly or are unrelated to the query's structure.