SOL-C01 Question #218: Real Exam Question with Answer & Explanation

Question

You are tasked with creating a development environment from a production database in Snowflake. The production database, 'PROD DB', is very large and you need to minimize the storage costs and time required for the cloning operation. The development environment should be isolated and allow developers to make changes without affecting production data. Which of the following approaches is the most efficient and cost- effective?

Options

• ACreate a full clone of 'PROD_Dff using 'CREATE DATABASE DEV_DB CLONE PROD_DB;'
• BCreate a zero-copy clone of 'PROD DB' using 'CREATE DATABASE DEV DB CLONE PROD DB;'
• CCreate a zero-copy clone of 'PROD_DB' using 'CREATE DATABASE DEV_DB CLONE PROD_DB
• DCreate a full backup of restore it to a new database 'DEV_DB', and then grant access to
• EExport the data from 'PROD to cloud storage, create a new database 'DEV DBS, and import the

Explanation

Snowflake cloning is a zero-copy operation. Using 'CREATE DATABASE DEV_DB CLONE PROD_DB',' creates a metadata copy instantly. The storage is only consumed when changes are made to the cloned database 'DEV DBA. This is the most efficient and cost-effective method. A, D, and E involve full data duplication which is slower and more expensive. C is also zero copy cloning but refers to a specific timestamp, which wasn't a requirement of the question.

No community discussion yet for this question.