SnowPro Advanced: Data Engineer — Question 71

A Data Engineer has created table T1 with DATA_RETENTION_TIME_IN_DAYS set to 7. There is a default stream S1 on table T1.

The parameter MAX_DATA_EXTENSION_TIME_IN_DAYS is set to 10 for table T1.

Based on these parameters, at MINIMUM, how frequently do the contents of stream S1 need to be consumed so that the stream does not become stale?

Answer options

• A. Every 3 days
• B. Every 7 days
• C. Every 10 days
• D. Every 30 days

Correct answer: C

Explanation

The correct answer is C, as the MAX_DATA_EXTENSION_TIME_IN_DAYS of 10 indicates that the stream must be consumed at least once every 10 days to avoid staleness. Options A and B do not meet the 10-day requirement, and option D exceeds the maximum time allowed, making them incorrect.