Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 9 of 60
Free Preview · 60 of 198 · questions 1–60 of 198 are free. Sign up free to sync your progress across devices.
Select 3 answers.
This question asks for 3 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
https://docs.snowflake.com/en/user-guide/querying-persisted-results
BCE are correct 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. https://docs.snowflake.com/en/user-guide/querying-persisted-results
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.