Secure data sharing basics in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Snowflake

CREATE SHARE [1];

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

Ashare1

Bshare_data

Cdata_share

Dmy_share

Attempts:

3 left

💡 Hint

Common Mistakes

Using a different share name than 'my_share'.

Forgetting the semicolon at the end.

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'

Asales_db

Bmarketing_db

Cfinance_db

Dhr_db

Attempts:

3 left

💡 Hint

Common Mistakes

Adding the wrong database to the share.

Misspelling the database name.

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 grant usage on the share 'my_share' to the account 'ACCOUNT_B'.

Snowflake

GRANT USAGE ON SHARE [1] TO ACCOUNT ACCOUNT_B;

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

Amyshare

Bmy_share

Cshare_my

Daccount_share

Attempts:

3 left

💡 Hint

Common Mistakes

Using a different share name than 'my_share'.

Omitting underscores in the share name.

The share name must be exactly 'my_share' to match the created share.

4fill in blank

hard

Fill both blanks to create a database from a share named 'my_share' in account 'ACCOUNT_A'.

Snowflake

CREATE DATABASE [1] FROM SHARE ACCOUNT_A.[2];

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

Ashared_sales_db

Bsales_db

Cmy_share

Daccount_a

Attempts:

3 left

💡 Hint

Common Mistakes

Using the original database name instead of a new name.

Mixing up the share name and database name.

The command creates a database named 'shared_sales_db' from the share 'my_share' in account 'ACCOUNT_A'.

5fill in blank

hard

Fill all three blanks to revoke usage on the share 'my_share' from account 'ACCOUNT_B'.

Snowflake

REVOKE [1] ON SHARE [2] FROM ACCOUNT [3];

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

AUSAGE

Bmy_share

CACCOUNT_B

DSELECT

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong privilege like SELECT instead of USAGE.

Misspelling the share or account names.

The command revokes USAGE privilege on the share 'my_share' from 'ACCOUNT_B'.