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 will meet these requirements?
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 will meet these requirements?
To disable Fail-safe for all tables, you need to create a transient database. A transient database doesn't have the Fail-safe period that is associated with permanent databases. Therefore, creating a transient database as a clone of the production database will meet the requirements to disable Fail-safe for all tables.
Both Transient and Temporary tables have 0 day Fail-safe and 0/1 day time travel. https://docs.snowflake.com/en/user-guide/tables-temp-transient
Because transient tables do not have a Fail-safe period, they provide a good option for managing the cost of very large tables used to store transitory data; however, the data in these tables cannot be recovered after the Time Travel retention period passes.
Transient doesn't mean it disappears. It just means it doesn't have fail-safe.
all the answers in this thread are wrong. There is a requirement to disable fail-safe, but nowhere does it mention the Dev DB is not permanent. Usually Development databases are not a short term thing as all current and future dev work should be done there. Answer is D. FAIL_SAFE argument does not exist for A to be correct.
Transient and Temp tables have 0 day Fail-Safe