Share security and governance in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to grant usage on a share to a specific role.

Snowflake

GRANT USAGE ON SHARE [1] TO ROLE analyst_role;

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

Amy_schema

Bmy_database

Cmy_share

Dmy_table

Attempts:

3 left

💡 Hint

Common Mistakes

Using a database or table name instead of the share name.

Forgetting to specify the role.

The USAGE privilege on a share allows the specified role to access the shared data. Here, my_share is the correct share name.

2fill in blank

medium

Complete the code to create a share with a comment describing its purpose.

Snowflake

CREATE SHARE [1] COMMENT = 'Share for sales data';

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

Asales_share

Bsales_db

Csales_schema

Dsales_table

Attempts:

3 left

💡 Hint

Common Mistakes

Using database or schema names instead of a share name.

Omitting the comment or using invalid syntax.

The CREATE SHARE command creates a new share named sales_share. The comment helps document the share's purpose.

3fill in blank

hard

Fix the error in the code to revoke share usage from a role.

Snowflake

REVOKE USAGE ON SHARE [1] FROM ROLE data_scientist;

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

Adata_schema

Bdata_database

Cdata_table

Ddata_share

Attempts:

3 left

💡 Hint

Common Mistakes

Using database or schema names instead of share name.

Misspelling the share name.

The REVOKE USAGE ON SHARE command removes access for the role data_scientist on the share named data_share. Using a database or table name causes an error.

4fill in blank

hard

Fill both blanks to grant select privilege on a shared table to a role.

Snowflake

GRANT SELECT ON [1].[2] TO ROLE reporting_role;

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

Ashared_db

Bshared_schema

Cshared_table

Dshared_share

Attempts:

3 left

💡 Hint

Common Mistakes

Using share name instead of database or table name.

Confusing schema and table names.

The command grants SELECT privilege on the table shared_table inside the schema shared_schema to the role reporting_role. The database is not specified here, so the schema and table are used.

5fill in blank

hard

Fill all three blanks to create a share, add a database to it, and grant usage to a role.

Snowflake

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

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

Afinance_share

Bfinance_db

Cfinance_analyst_role

Dfinance_schema

Attempts:

3 left

💡 Hint

Common Mistakes

Using schema name instead of database name when adding to share.

Granting usage to a database or schema instead of a role.

Confusing share and database names.

This sequence creates a share named finance_share, adds the database finance_db to the share, and grants usage on the share to the role finance_analyst_role. The schema is not added directly to the share.