If a schema has a retention time of 10 days, a table in that schema with no explicit retention will inherit 10 days.

• A. True
• B. False
• C. Only databases inherit
• D. Not relevant

Answer: (A)

Data retention time in Snowflake is a property that can be set at the database, schema, or table level, and child objects inherit the retention value from their nearest parent unless they have their own explicit setting. Here, the schema has a retention time of 10 days, and the table does not define its own retention. As a result, the table uses the schema's 10-day retention, so its Time Travel window is 10 days. If you later set an explicit retention on the table, that would override the inherited value; otherwise the inherited setting remains in effect.