Exam SnowPro Core topic 1 question 481 discussion

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

A. MAX_DATA_EXTENSION_TIME_IN_DAYS

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.

https://docs.snowflake.com/en/user-guide/streams-intro#label-streams-staleness

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.

https://docs.snowflake.com/en/user-guide/streams-intro#label-streams-staleness

The answer is correct. https://docs.snowflake.com/en/user-guide/streams-manage