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

Question

Options

• AEvery 3 days
• BEvery 7 days
• CEvery 10 days
• DEvery 30 days

• A
  9% (3)
• B
  3% (1)
• C
  69% (22)
• D
  19% (6)

Explanation

Option C is correct because Snowflake automatically extends a table's data retention period beyond DATA_RETENTION_TIME_IN_DAYS (7 days) when a stream exists on it - but only up to the value of MAX_DATA_EXTENSION_TIME_IN_DAYS (10 days). This extension exists specifically to prevent streams from going stale, making the effective staleness window 10 days, not 7.

Option A (3 days) is wrong - no parameter here yields 3; it appears to be a distractor with no basis in these settings.

Option B (7 days) is the most tempting wrong answer - it's the base retention period, but it ignores the automatic extension Snowflake provides via MAX_DATA_EXTENSION_TIME_IN_DAYS, which pushes the deadline out to 10 days.

Option D (30 days) is wrong - 30 days is the default value of MAX_DATA_EXTENSION_TIME_IN_DAYS when it hasn't been explicitly set, but here it's explicitly configured to 10.

Memory tip: Think of MAX_DATA_EXTENSION_TIME_IN_DAYS as the "stream safety net ceiling." Snowflake stretches the retention floor upward to meet it - so the stream's deadline is always driven by the extension cap, not the base retention.

No community discussion yet for this question.