Creating and managing shares in Snowflake - Practice Exercises

Challenge - 5 Problems

❓ service_behavior

intermediate

What happens when you create a share without adding any objects?

You create a share in Snowflake but do not add any databases or schemas to it. What will be the state of this share?

Snowflake

CREATE SHARE my_share;

A The share automatically includes all existing databases in your account.

B The share is created but contains no data and cannot be used to share data until objects are added.

C The share creation fails with an error because no objects were specified.

D The share includes only the default public schema automatically.

💡 Hint

Think about what a share represents and what it needs to share data.

A share in Snowflake is a container for database objects to share. Creating it without adding objects results in an empty share that cannot share data until objects are added.

❓ Configuration

intermediate

Which command correctly adds a database to an existing share?

You have an existing share named my_share. You want to add the database sales_db to this share. Which command is correct?

A ALTER SHARE my_share INCLUDE DATABASE sales_db;

B ALTER SHARE my_share ADD sales_db;

C ALTER SHARE my_share ADD DATABASE sales_db;

D ALTER SHARE my_share ADD DATABASE = sales_db;

💡 Hint

Recall the syntax for adding objects to a share in Snowflake.

The correct syntax to add a database to a share is ALTER SHARE <share_name> ADD DATABASE <database_name>;

❓ security

advanced

What is the effect of revoking usage on a share from a consumer account?

You revoke usage privileges on a share from a consumer account. What happens to the consumer's access to the shared data?

A The consumer can still query the data but cannot create new shared databases from the share.

B The consumer retains access until their current session ends.

C The consumer immediately loses access to all shared data from that share.

D The consumer's access is unaffected; revoking usage only affects the provider.

💡 Hint

Consider what revoking usage means for shared data access.

Revoking usage on a share prevents the consumer from creating new databases from the share but existing shared databases remain accessible for querying.

❓ Architecture

advanced

How does Snowflake handle data consistency when sharing data across accounts?

When a provider shares data with a consumer account, how does Snowflake ensure the consumer sees consistent data?

A Snowflake copies the data physically to the consumer's account to ensure consistency.

B Snowflake requires manual refreshes by the consumer to update shared data.

C Snowflake uses a zero-copy cloning mechanism to provide a consistent snapshot of the data at the time of sharing.

D The consumer always sees the latest live data with no snapshot guarantees.

💡 Hint

Think about how Snowflake shares data efficiently without duplication.

Snowflake Secure Data Sharing provides live access to the provider's data using zero-copy technology, so consumers always see the latest data.

✅ Best Practice

expert

What is the recommended approach to share only specific tables from a database?

You want to share only certain tables from a database with an external account. What is the best practice to achieve this in Snowflake?

A Add only the specific schemas containing the tables to the share; tables outside those schemas are excluded.

B Add the entire database to the share and restrict access using roles on the consumer side.

C Create a new database containing only the desired tables and share that database.

D Add the entire database to the share and use masking policies to hide unwanted tables.

💡 Hint

Consider how shares work at the database and schema level.

Snowflake shares data at the database and schema level. To share specific tables, add only the schemas containing those tables to the share.