Which parameter prevents streams on tables from becoming stale?
Which parameter prevents streams on tables from becoming stale?
The correct parameter is STALE_AFTER. This parameter specifies the number of seconds before a stream becomes stale, ensuring that the stream does not become outdated and continues to provide a complete record of changes to the underlying table. Utilizing STALE_AFTER allows for the setting of a threshold for when the stream should be refreshed to maintain data consistency.
The answer is correct. https://docs.snowflake.com/en/user-guide/streams-manage
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.
The STALE_AFTER column timestamp indicates when the stream is currently predicted to become stale, don't put junk answers..
https://docs.snowflake.com/en/user-guide/streams-intro#label-streams-staleness
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.
you sir are an idiot.
https://docs.snowflake.com/en/user-guide/streams-intro#label-streams-staleness