Clone use cases (dev, testing, backups) in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a clone of a database for development use.

Snowflake

CREATE DATABASE dev_clone CLONE [1];

Drag options to blanks, or click blank then click option'

Atest_db

Bproduction_db

Cbackup_db

Darchive_db

Attempts:

3 left

💡 Hint

Common Mistakes

Cloning from a test or backup database instead of production.

Using incorrect database names.

The production_db is cloned to create a development environment without affecting the original data.

2fill in blank

medium

Complete the code to clone a schema for testing purposes.

Snowflake

CREATE SCHEMA test_schema_clone CLONE [1].sales_schema;

Drag options to blanks, or click blank then click option'

Aprod_db

Bbackup_db

Cdev_db

Darchive_db

Attempts:

3 left

💡 Hint

Common Mistakes

Cloning from development or backup databases.

Using the wrong database name.

The prod_db is cloned to create a test schema, allowing safe testing without impacting production.

3fill in blank

hard

Fix the error in the clone creation command for backup purposes.

Snowflake

CREATE DATABASE backup_clone [1] backup_db;

Drag options to blanks, or click blank then click option'

ADUPLICATE

BCOPY

CCLONE

DREPLICATE

Attempts:

3 left

💡 Hint

Common Mistakes

Using COPY instead of CLONE.

Using unsupported keywords like DUPLICATE or REPLICATE.

The correct keyword to create a clone in Snowflake is CLONE. Other keywords like COPY or DUPLICATE are invalid here.

4fill in blank

hard

Fill both blanks to clone a table for testing and rename it.

Snowflake

CREATE TABLE [1] CLONE [2].orders;

Drag options to blanks, or click blank then click option'

Atest_orders

Bprod_db

Cdev_db

Dbackup_orders

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong source database.

Naming the clone with a confusing or incorrect name.

The table orders from prod_db is cloned and renamed test_orders for testing.

5fill in blank

hard

Fill all three blanks to clone a database for backup, set a comment, and specify a clone time.

Snowflake

CREATE DATABASE [1] CLONE [2] AT (TIMESTAMP => '[3]');

Drag options to blanks, or click blank then click option'

Abackup_db_clone

Bproduction_db

C2024-06-01 00:00:00

Dtest_db

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong database name for cloning.

Incorrect timestamp format.

Confusing test and production databases.

This command clones the production_db as backup_db_clone at the specified timestamp for backup purposes.