https://docs.snowflake.com/en/user-guide/streams-intro#label-streams-staleness
To prevent a stream from becoming stale, consume the stream records within a DML statement during the table’s retention period and regularly consume its change data before its STALE_AFTER timestamp (that is, within the extended data retention period for the source object).
The question is not well formed, but i think is A
STALE_AFTER is the date when a stream is predicted to become stale, and that value is determined as the larger of DATA_RETENTION_TIME_IN DAYS or MAX_DATA_EXTENSION_TIME_IN_DAYS added to the current timestamp
The correct ans is D
The STALE_AFTER Parameter prevent stream become a stale, it predict timestamp when the stream was become a stale, we need to consume its change data before its STALE_AFTER timestamp.
D. STALE_AFTER is a parameter for streams in Snowflake that determines when a stream is considered stale and should be refreshed. It specifies the number of seconds before a stream becomes stale, and can be set to any value between 60 seconds and 14,400 seconds (4 hours). When a stream becomes stale, it is no longer guaranteed to contain a complete record of changes to the underlying table, and should be refreshed to ensure consistency.
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.
PrasantSadangi
3 months, 2 weeks agoNachoPrendes
9 months, 3 weeks ago_yyukta
10 months, 1 week agoVijay2605
10 months, 3 weeks agoMultiCloudIronMan
1 year, 6 months agoisolated_sniper
1 year, 8 months agoKarBiswa
1 year, 10 months agosjndds
1 year, 11 months ago