Why data sharing eliminates data copies in Snowflake - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a share in Snowflake.

Snowflake

CREATE SHARE [1];

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

ATABLE

Bmy_share

CDATABASE

DSCHEMA

Attempts:

3 left

💡 Hint

Common Mistakes

Using keywords like DATABASE instead of a share name.

The CREATE SHARE command creates a new share object in Snowflake.

2fill in blank

medium

Complete the code to add a database to the share.

Snowflake

ALTER SHARE my_share ADD DATABASE [1];

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

Amy_schema

Bmy_user

Cmy_database

Dmy_table

Attempts:

3 left

💡 Hint

Common Mistakes

Adding a schema or table instead of a database.

The ADD DATABASE clause adds a database to the share.

3fill in blank

hard

Fix the error in the code to grant usage on the share to a consumer account.

Snowflake

GRANT USAGE ON SHARE my_share TO ACCOUNT [1];

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

Amy_database

Bmy_share

C12345

Dconsumer_account

Attempts:

3 left

💡 Hint

Common Mistakes

Using numbers or share/database names instead of account name.

You must specify the consumer account name to grant usage on the share.

4fill in blank

hard

Fill both blanks to create a database from a share for the consumer.

Snowflake

CREATE DATABASE [1] FROM SHARE [2];

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

Ashared_db

Bmy_share

Cconsumer_db

Dmy_database

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the share and database names.

The consumer creates a database named consumer_db from the provider's share my_share.

5fill in blank

hard

Fill all three blanks to explain why data sharing eliminates data copies.

Snowflake

Data sharing in Snowflake works by [1] data access, not by [2] data. This means the consumer accesses the provider's data [3] without creating copies.

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

Adirect

Bcopying

Cremotely

Dduplicating

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'duplicating' instead of 'copying' or mixing access and copy concepts.

Snowflake data sharing allows direct access to data without copying it, so consumers access data remotely.