Does Snowflake support creating TRANSIENT databases and schemas?

• A. False
• B. True
• C. Only in pilot
• D. Not supported

Answer: (B)

The test checks whether you can use the TRANSIENT option for databases and schemas in Snowflake. Yes, you can. Snowflake supports creating a database or a schema as TRANSIENT, which means those objects don’t have Fail-Safe protection. You still retain Time Travel for the retention window, so you can recover data within that period, but you won’t have the additional Fail-Safe guarantee. This is why the statement is true: TRANSIENT databases and schemas are supported, and they help reduce durability costs while keeping Time Travel. The option isn’t limited to a pilot program, and it isn’t a case of “not supported.”