BCE are correct due to the following reasons:
For persisted query results of all sizes, the cache expires after 24 hours.
Each time the persisted result for a query is reused, Snowflake resets the 24-hour retention period for the result, up to a maximum of 31 days from the date and time that the query was first executed. After 31 days, the result is purged and the next time the query is submitted, a new result is generated and persisted.
How is F not a correct answer? It is more correct than B, since a result cache be kicked out of memory before 24 hours if there are newer results coming in.
F, E, C, B, A is valid. I have a doubt with A, but the rest is fine. Are these questions well posed? Or does it refer only to the features that are explicitly in the documentation? B, C, E 100%, since it is in the documentation explicitly, but F AND B are fine implicitly.
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.
MSIDDIQUI18
3 weeks, 5 days ago67422cb
6 months agocarloscloud
11 months agoGLEM
1 year, 4 months agohillcat111
1 year, 4 months agoNeedium
1 year, 6 months agoserg_khar
1 year, 7 months ago