SnowPro Core Certification — Question 472

Which parameter prevents streams on tables from becoming stale?

Answer options

• A. MAX_DATA_EXTENSION_TIME_IN_DAYS
• B. MIN_DATA_RETENSION_TIME_IN_DAYS
• C. LOCK_TIMEOUT
• D. STALE_AFTER

Correct answer: A

Explanation

The MAX_DATA_EXTENSION_TIME_IN_DAYS parameter is designed to limit the time that streams can be extended, thus preventing them from becoming stale. The MIN_DATA_RETENSION_TIME_IN_DAYS option does not control staleness but rather the minimum duration for which data must be retained. LOCK_TIMEOUT is unrelated to stream freshness and pertains to how long a lock can be held, while STALE_AFTER defines a threshold for considering data stale but does not actively prevent it.