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