SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ21

Implement Data Protection and Recovery

A Data Engineer created table T1 with DATA_RETENTION_TIME_IN_DAYS set to 7. A default stream, S1, exists on table T1.

The MAX_DATA_EXTENSION_TIME_IN_DAYS parameter is set to 10 for table T1.

Based on these parameters, at a minimum, how often must the contents of stream S1 be consumed to keep the stream from becoming stale?

Explanation

A table stream’s STALE_AFTER deadline uses the greater of DATA_RETENTION_TIME_IN_DAYS and MAX_DATA_EXTENSION_TIME_IN_DAYS from the source table. With values of 7 and 10, respectively, the stream data must be consumed within 10 days; consuming it advances the stream offset and staleness deadline.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!