Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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.
The answer is correct.
https://docs.snowflake.com/en/user-guide/streams-manage
upvoted 4 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.
NachoPrendes
1 month ago_yyukta
1 month, 3 weeks agoVijay2605
2 months agoicegrandpa
2 months agoMultiCloudIronMan
9 months, 3 weeks agoisolated_sniper
11 months, 4 weeks agoRam9198
5 months, 4 weeks agoKarBiswa
1 year, 1 month agosjndds
1 year, 2 months ago