SnowflakeSnowflake
COF-C02 · Question #283
COF-C02 Question #283: Real Exam Question with Answer & Explanation
The correct answer is A: MAXDATAEXTENSIONTIMEINDAYS. The parameter that prevents streams on tables from becoming stale is MAXDATAEXTENSIONTIMEINDAYS. This parameter specifies the maximum number of days for which Snowflake can extend the data retention period for the table to prevent streams on the table from becoming stale.
Data Transformations
Question
Which parameter prevents streams on tables from becoming stale?
Options
- AMAXDATAEXTENSIONTIMEINDAYS
- BMTN_DATA_RETENTION_TTME_TN_DAYS
- CLOCK_TIMEOUT
- DSTALE_AFTER
Explanation
The parameter that prevents streams on tables from becoming stale is MAXDATAEXTENSIONTIMEINDAYS. This parameter specifies the maximum number of days for which Snowflake can extend the data retention period for the table to prevent streams on the table from becoming stale.
Topics
#Streams#Data Staleness#Data Retention#Table Parameters
Community Discussion
No community discussion yet for this question.