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

All child objects will retain data for the new retention period.

All child objects that do not have an explicit retention period will automatically inherit the new retention period.

All child objects with an explicit retention period will be overridden with the new retention period.

All explicit child object retention periods will remain unchanged.