C is explained here "The table’s micro-partitions have not changed (e.g. been reclustered or consolidated) due to changes to other data in the table."
https://docs.snowflake.com/en/user-guide/querying-persisted-results.html
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.
Re-clustering data does not invalidate the ResultSet cache. The cache is based on query text and the state of the data, not how the data is physically stored. Answer: AE
If "Changing a column that is not in the cached query" means changing such column's name or updating the data of that column then ACE are correct answers.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
SV1122
Highly Voted 2 years, 1 month agoMike722
1 year agoChewyRemedy
Most Recent 6 months, 1 week agoJRayan
6 months, 2 weeks agoMultiCloudIronMan
7 months ago37ceea2
6 months agoNPass
7 months, 1 week agoabhijit2683
10 months, 2 weeks agorogerek077
10 months, 3 weeks ago_yyukta
11 months, 4 weeks agomajew
1 year agosandy91
1 year, 1 month agoumidjon03
1 year, 2 months agoJangelovska
1 year, 3 months agoNEMMELA
1 year, 5 months agoarsalanramin
1 year, 5 months agoMultiCloudIronMan
1 year, 7 months agojayeshtest
1 year, 7 months agopinklove
1 year, 8 months ago