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 1 year, 9 months agoMike722
8 months, 1 week agoChewyRemedy
Most Recent 2 months agoJRayan
2 months, 1 week agoMultiCloudIronMan
3 months ago37ceea2
1 month, 4 weeks agoNPass
3 months, 1 week agoabhijit2683
6 months, 2 weeks agorogerek077
6 months, 2 weeks ago_yyukta
7 months, 3 weeks agomajew
8 months, 2 weeks agosandy91
9 months agoumidjon03
10 months, 2 weeks agoJangelovska
11 months, 2 weeks agoNEMMELA
1 year, 1 month agoarsalanramin
1 year, 1 month agoMultiCloudIronMan
1 year, 3 months agojayeshtest
1 year, 3 months agopinklove
1 year, 3 months ago