
Answer-first summary for fast verification
Answer: All child objects that do not have an explicit retention period will automatically inherit the new retention period.
The correct answer is B because when a schema's data retention period is modified, only child objects without explicit retention settings inherit the new period. Objects with explicit retention periods (like table T_B in the community test) remain unchanged, which aligns with option D. However, since the question asks for a single answer and B encompasses the inheritance behavior for non-explicit objects while implying that explicit ones are unaffected, B is the optimal choice. Option A is incorrect as not all child objects retain the new period (explicit ones don't), and option C is wrong because explicit periods are not overridden. The community discussion, including upvoted comments and test results, confirms that B is correct, with some noting D is also valid but B is preferred for single-answer selection.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When a user modifies the data retention period for a schema in Snowflake, what is the effect on the existing and future tables within that schema?
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.
No comments yet.