SnowPro Advanced: Data Engineer — Question 5

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?

Answer options

• A. CREATE DATABASE DEV - CLONE PROD - FAIL_SAFE = FALSE;
• B. CREATE DATABASE DEV - CLONE PROD;
• C. CREATE TRANSIENT DATABASE DEV - CLONE PROD;
• D. CREATE DATABASE DEV - CLONE PROD - DATA_RETENTION_TIME_IN DAYS = 0;

Correct answer: C

Explanation

The correct answer is C, as creating a transient database allows for cloning without Fail-safe, which is a requirement in this scenario. Options A and D attempt to set properties that are not applicable for the desired scenario, while B does not address the need to disable Fail-safe.