Snowpro Core · Free Practice Question Easy
Question 44
If the query result cache for a query is not used by any future query, what is the duration after which it will be purged?
- A 31 days
- B 24 hours
- C 365 days
- D 3600 seconds
Reveal correct answer
Correct answer: B
Explanation
Once a result cache is generated for a query stays valid for 24 hours. If another query that reuses the query result cache is executed within that 24-hour window, the result cache expiry is extended for another 24 hours from that point onwards. If the result cache for a query keeps getting used, it will stay valid for up to 31 days. After 31 days, the result cache for a query will be purged regardless of any other condition. https://docs.snowflake.com/en/user-guide/querying-persisted-resultsDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
