Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Core Certification · Snowflake
Select 2 answers.
This question asks for 2 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
AE A. Removing a column from the query SELECT list Snowflake’s ResultSet cache is exact‑match only. If you change anything in the query text — even removing a column — Snowflake treats it as a different query and will not reuse the cached result. E. Changing a column that is not in the cached query Even if the changed column wasn’t selected, Snowflake still invalidates the ResultSet cache because the underlying data used by the query has changed. ResultSet cache requires no changes to any table data referenced by the query. Why not C: Clustering affects micro‑partition pruning and performance, not the ResultSet cache.
If you modify the query, such as by removing or adding a column, the ResultSet cache cannot be leveraged since the query is now different from the one that was previously cached. Clustering changes the physical storage of the data, which affects the query results and prevents the use of the ResultSet cache.
AE is the correct answer