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

Question

A data analyst wants to clone the 'SALES DB' database to create a development environment called "DEV SALES DB'. The analyst needs to ensure that all schemas within 'SALES DB' , including custom schemas with data, are replicated in the clone, and that the clone operates as a completely independent database. Which of the following sequence of commands is the most efficient and reliable way to achieve this?

Options

• ACREATE DATABASE CREATE SCHEMA CREATE SCHEMA Repeat for all schemas in
• BCREATE DATABASE DEV SALES DB CLONE SALES DB;
• CBACKUP DATABASE SALES DB TO S3; RESTORE DATABASE DEV SALES DB FROM S3;
• DCREATE OR REPLACE DATABASE DEV SALES DBAS COPY OF SALES DB;
• ECREATE DATABASE DEV SALES DB CLONE SALES DB COPY GRANTS;

Explanation

'CREATE DATABASE CLONE SALES_DB;' is the correct and most efficient way to clone a database in Snowflake. It creates a point-in-time snapshot clone of the entire database, including all schemas, tables, and other objects. Option A is manual and highly inefficient. Option C involves backups and restores, which are not the intended approach for cloning within Snowflake. Option D's syntax is incorrect as 'AS COPY OF is not a valid clause, and 'COPY GRANTS' with clone may not be relevant here.

No community discussion yet for this question.