Answer-first summary for fast verification
Answer: The data retention period is temporarily extended to the stream’s offset.
The correct answer is C because Snowflake documentation and community consensus confirm that when a stream exists on a table and has not been consumed, Snowflake temporarily extends the data retention period to the stream's offset. This ensures the stream data remains available until consumed. Option A is incorrect as the retention period is extended, not reduced. Option B is wrong because the extension is temporary, not permanent. Option D is incorrect as stream consumption does affect the retention period. The community discussion shows unanimous support for C with upvoted comments referencing official documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
If a stream exists on a table and has not been consumed, how does Snowflake handle the data retention period for that table?
A
The data retention period s reduced to a minimum of 14 days.
B
The data retention period is permanently extended for the table.
C
The data retention period is temporarily extended to the stream’s offset.
D
The data retention period is not affected by the stream consumption.
No comments yet.