Undrop for recovering dropped objects in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to recover a dropped table named 'sales_data'.

Snowflake

UNDROP TABLE [1];

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

Asales_data

Bsales

Cdata_sales

DsalesTable

Attempts:

3 left

💡 Hint

Common Mistakes

Using a wrong or partial table name.

Forgetting to specify the table name.

The UNDROP TABLE command recovers the dropped table by its exact name.

2fill in blank

medium

Complete the code to recover a dropped schema named 'analytics'.

Snowflake

UNDROP [1] analytics;

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

ADATABASE

BTABLE

CVIEW

DSCHEMA

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'DATABASE' or 'TABLE' instead of 'SCHEMA'.

Omitting the object type keyword.

The UNDROP SCHEMA command recovers a dropped schema by name.

3fill in blank

hard

Fix the error in the code to recover a dropped database named 'sales_db'.

Snowflake

UNDROP DATABASE [1];

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

Asales-db

Bsalesdb

Csales_db

D'sales_db'

Attempts:

3 left

💡 Hint

Common Mistakes

Using quotes around the database name.

Using incorrect database name spelling.

The database name should be specified exactly without quotes or special characters.

4fill in blank

hard

Fill both blanks to recover a dropped table named 'orders' in schema 'public'.

Snowflake

UNDROP TABLE [1].[2];

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

Apublic

Bsales

Corders

Ddata

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping schema and table names.

Using wrong schema or table names.

The syntax requires schema name first, then table name separated by a dot.

5fill in blank

hard

Fill all three blanks to recover a dropped view named 'monthly_report' in schema 'finance' of database 'corp_db'.

Snowflake

UNDROP VIEW [1].[2].[3];

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

Acorp_db

Bfinance

Cmonthly_report

Dpublic

Attempts:

3 left

💡 Hint

Common Mistakes

Incorrect order of database, schema, and view.

Using wrong object names.

The full object name includes database, schema, and view separated by dots.