Answer: MAX_DATA_EXTENSION_TIME_IN_DAYS

The correct answer is A (MAX_DATA_EXTENSION_TIME_IN_DAYS) based on Snowflake documentation and community consensus. According to Snowflake's official documentation on stream staleness, streams can be extended beyond the standard data retention period using MAX_DATA_EXTENSION_TIME_IN_DAYS parameter, which prevents them from becoming stale by allowing more time to consume change data. The community discussion shows strong consensus for option A with multiple references to official documentation and higher upvotes. Option D (STALE_AFTER) is incorrect because it's not a parameter that prevents staleness - it's actually a timestamp that indicates when a stream is predicted to become stale, not a parameter that prevents it. Options B and C are unrelated to stream staleness prevention.

Author: LeetQuiz Editorial Team