SnowPro Core Certification — Question 947

How does Snowflake handle the data retention period for a table if a stream has not been consumed?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because Snowflake allows the data retention period to be extended temporarily to align with the stream's offset, ensuring that unconsumed data is available for potential use. Options A and B are incorrect as they misrepresent the retention policies, and option D is also wrong because it overlooks the impact of stream consumption on retention.