Zero-copy cloning in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a zero-copy clone of a table named 'sales_data'.

Snowflake

CREATE TABLE sales_data_clone CLONE [1];

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

Asales_data

Bsales_data_clone

Csales

Dclone_table

Attempts:

3 left

💡 Hint

Common Mistakes

Using the clone table name instead of the original table name.

Misspelling the source table name.

The CLONE keyword is used to create a zero-copy clone of the existing table sales_data.

2fill in blank

medium

Complete the code to clone a database named 'analytics_db' using zero-copy cloning.

Snowflake

CREATE DATABASE analytics_db_clone CLONE [1];

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

Aanalytics

Banalytics_db

Canalytics_db_clone

Dclone_db

Attempts:

3 left

💡 Hint

Common Mistakes

Using the clone database name as the source.

Using an incorrect database name.

The CLONE keyword clones the original database analytics_db without copying data.

3fill in blank

hard

Fix the error in the code to clone a schema named 'public' from database 'sales_db'.

Snowflake

CREATE SCHEMA sales_db_clone.public CLONE [1];

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

Asales_db_clone.public

Bsales_db_clone

Csales_db.public

Dpublic

Attempts:

3 left

💡 Hint

Common Mistakes

Using the clone schema name as the source.

Using only the schema name without database.

The source schema must be fully qualified with the original database and schema name: sales_db.public.

4fill in blank

hard

Fill both blanks to clone a table named 'orders' from schema 'sales' in database 'retail_db' into a new schema 'sales_clone'.

Snowflake

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

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

Aretail_db

Bsales

Csales_clone

Dorders

Attempts:

3 left

💡 Hint

Common Mistakes

Using the clone schema name instead of the original schema.

Swapping database and schema names.

The clone source must specify the original database and schema: retail_db.sales.orders.

5fill in blank

hard

Fill all three blanks to clone a zero-copy clone of a stage named 'data_stage' from database 'prod_db' and schema 'public' into a new stage in schema 'dev_schema'.

Snowflake

CREATE STAGE dev_schema.data_stage_clone CLONE [1].[2].[3];

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

Aprod_db

Bpublic

Cdata_stage

Ddev_schema

Attempts:

3 left

💡 Hint

Common Mistakes

Using the clone schema or stage name as source.

Missing one of the three parts in the source.

The clone source must be fully qualified with database, schema, and stage name: prod_db.public.data_stage.