SnowPro Core Certification — Question 874

What happens when a Snowflake user changes the data retention period at the schema level?

Answer options

• A. All child objects will retain data for the new retention period.
• B. All child objects that do not have an explicit retention period will automatically inherit the new retention period.
• C. All child objects with an explicit retention period will be overridden with the new retention period.
• D. All explicit child object retention periods will remain unchanged.

Correct answer: B

Explanation

The correct answer is B because only child objects without an explicit retention period will automatically inherit the new setting. Options A and C are incorrect as they misrepresent the behavior regarding inheritance and overrides, while D is wrong because it does not consider the objects without explicit retention periods that would adopt the new setting.