A Data Engineer wants to create a new development database (DEV) as a clone of the permanent production database (PROD). There is a requirement to disable Fail-safe for all tables. Which command…

Question

Options

• ACREATE DATABASE DEV
• BCREATE DATABASE DEV
• CCREATE TRANSIENT DATABASE DEV
• DCREATE DATABASE DEV

• A
  6% (4)
• B
  1% (1)
• C
  91% (63)
• D
  1% (1)

Explanation

Option C is correct because CREATE TRANSIENT DATABASE DEV (with an implied CLONE PROD) creates a transient database, which has zero days of Fail-safe by default - and critically, all tables created within a transient database automatically inherit the transient storage type, meaning Fail-safe is disabled for all of them at the database level.

Options A, B, and D all use CREATE DATABASE DEV (permanent database type). Permanent databases carry a 7-day Fail-safe period that cannot be disabled at the table level - you'd have to manually alter every table to transient after creation, which is error-prone and not what was asked.

Memory tip: Think "TRANSIENT = Temporary & No Safety net." Transient objects in Snowflake sacrifice both Fail-safe (0 days) and have limited/no Time Travel, which makes them ideal for dev/test environments where you want to reduce storage costs and don't need disaster recovery protection. The word transient itself means "temporary/fleeting" - a fitting reminder that safety features are stripped away.

Key rule to memorize: Permanent DB → Fail-safe ON (7 days, mandatory). Transient DB → Fail-safe OFF (0 days, always). You cannot selectively disable Fail-safe on tables inside a permanent database.

No community discussion yet for this question.