Creating and managing shares in Snowflake - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a new share named 'my_share'.

Snowflake

CREATE SHARE [1];

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

Amy_share

Bshare1

Cdata_share

Dnew_share

Attempts:

3 left

💡 Hint

Common Mistakes

Using a different share name than 'my_share'.

Omitting the share name after CREATE SHARE.

The command CREATE SHARE my_share; creates a new share named 'my_share'.

2fill in blank

medium

Complete the code to add the database 'sales_db' to the share 'my_share'.

Snowflake

ALTER SHARE my_share ADD DATABASE [1];

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

Afinance_db

Bmarketing_db

Chr_db

Dsales_db

Attempts:

3 left

💡 Hint

Common Mistakes

Adding the wrong database name.

Forgetting to specify the database after ADD DATABASE.

The command ALTER SHARE my_share ADD DATABASE sales_db; adds the 'sales_db' database to the share.

3fill in blank

hard

Fix the error in the code to remove the database 'marketing_db' from the share 'my_share'.

Snowflake

ALTER SHARE my_share [1] DATABASE marketing_db;

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

ADROP

BDELETE

CREMOVE

DCLEAR

Attempts:

3 left

💡 Hint

Common Mistakes

Using DELETE or REMOVE instead of DROP.

Omitting the DROP keyword.

The correct syntax to remove a database from a share is ALTER SHARE my_share DROP DATABASE marketing_db;.

4fill in blank

hard

Fill both blanks to grant usage on the share 'my_share' to the account 'partner_account'.

Snowflake

GRANT [1] ON SHARE my_share TO ACCOUNT [2];

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

AUSAGE

BSELECT

Cpartner_account

DREAD

Attempts:

3 left

💡 Hint

Common Mistakes

Using SELECT or READ instead of USAGE.

Using the wrong account name.

The command GRANT USAGE ON SHARE my_share TO ACCOUNT partner_account; allows the partner account to use the share.

5fill in blank

hard

Fill all three blanks to create a share named 'analytics_share', add the database 'analytics_db', and grant usage to account 'client_account'.

Snowflake

CREATE SHARE [1]; ALTER SHARE [2] ADD DATABASE [3]; GRANT USAGE ON SHARE [2] TO ACCOUNT client_account;

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

Aanalytics_share

Banalytics_db

Dsales_db

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up share and database names.

Using the wrong share name in ALTER and GRANT commands.

This sequence creates the share 'analytics_share', adds the 'analytics_db' database, and grants usage to 'client_account'.