In Snowflake, all tables created in a transient schema, as well as all schemas created in a transient database, are transient by definition.

• A. Only schemas are transient
• B. Only tables are transient
• C. False
• D. True

Answer: (D)

Transient is a setting that applies to the object and cascades to its descendants. When you create a database as TRANSIENT, Snowflake treats all schemas inside it as transient by default. Likewise, when you create a schema as TRANSIENT, all tables created within that schema are transient by default. This is why the statement is true: nested objects inherit the transient designation from their parent container.