Which parameter prevents streams on tables from becoming stale?

The correct answer is A. MAXDATAEXTENSIONTIMEINDAYS. Streams become stale when the stream's offset (its change-tracking position) falls outside the table's data retention period. The MAX_DATA_EXTENSION_TIME_IN_DAYS (A) parameter controls the maximum number of additional days Snowflake will extend a table's data retention period…

Data Transformations

Question

Options

AMAXDATAEXTENSIONTIMEINDAYS
BMTN_DATA_RETENTION_TTME_TN_DAYS
CLOCK_TIMEOUT
DSTALE_AFTER

How the community answered

(25 responses)

A
88% (22)
B
8% (2)
C
4% (1)

Explanation

Streams become stale when the stream's offset (its change-tracking position) falls outside the table's data retention period. The MAX_DATA_EXTENSION_TIME_IN_DAYS (A) parameter controls the maximum number of additional days Snowflake will extend a table's data retention period specifically to prevent any active streams on that table from going stale. When a stream is active, Snowflake automatically extends retention up to this limit so the stream offset remains valid.

Topics

#Streams#Data Staleness#Data Retention#Table Parameters

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice