What is the MAXIMUM number of days that Snowflake resets the 24-hour retention period for a query result every time the result is used?
What is the MAXIMUM number of days that Snowflake resets the 24-hour retention period for a query result every time the result is used?
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.
given ans is 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.
C - 31
Correct
https://docs.snowflake.com/en/user-guide/querying-persisted-results#:~:text=Each%20time%20the%20persisted%20result%20for%20a%20query%20is%20reused%2C%20Snowflake%20resets%20the%2024%2Dhour%20retention%20period%20for%20the%20result%2C%20up%20to%20a%20maximum%20of%2031%20days%20from%20the%20date%20and%20time%20that%20the%20query%20was%20first%20executed.