SnowPro Advanced Data Sharing Architecture

1. Which of the following are benefits of using Snowflake data sharing? Select all that apply.

No data movement or copying required

Reduced storage costs for consumers

Live access to current data

Requires ETL processes for setup

Submit

2. Which of the following is a key limitation of Snowflake data sharing?

Both accounts must be in the same cloud region

Shared data cannot include views

Only five objects can be shared per account

Consumers cannot create databases

3. True or False: Provider accounts can track which consumer accounts accessed their shared data.

True

False

Submit

5. In Snowflake Marketplace, what is a listing?

A catalog entry for a data product available for purchase or free consumption

A user account in the system

A database backup schedule

A query execution plan

6. What is the primary advantage of using a reader account versus a standard consumer account?

Lower cost with consumption-based pricing

Higher query performance

Unlimited data access

No compute resource requirements

7. Which Snowflake role is required to create and manage shares in a provider account?

SYSADMIN

ACCOUNTADMIN

PUBLIC

VIEWER

8. True or False: A consumer account can modify data in shared tables without provider approval.

True

False

Submit

10. What happens to a share when the provider account deletes a shared object?

The object remains accessible in consumer accounts

The object immediately becomes inaccessible

A copy is created for each consumer

The share is automatically revoked

11. What is the primary purpose of a Snowflake share object in data sharing architecture?

To grant access to specific database objects across Snowflake accounts

To replicate entire databases automatically

To manage user authentication credentials

To monitor query performance metrics

12. True or False: Snowflake shares support real-time data synchronization between provider and consumer accounts.

True

False

13. What is the purpose of the GRANT USAGE ON SHARE command?

To permit an account to use objects within a share

To create new share objects

To modify consumer account permissions

To revoke access immediately

14. Which system function returns the list of shares available to a consumer account?

LIST_SHARES()

SHOW SHARES

GET_AVAILABLE_SHARES()

DESCRIBE SHARES

15. In Snowflake Marketplace, what role does a provider account play?

Publishes data products for discovery and consumption

Manages all user accounts globally

Monitors all query performance

Handles billing for all accounts

16. What is the maximum number of accounts that can consume a single share in Snowflake?

10 accounts

50 accounts

Unlimited accounts

100 accounts

17. Which of the following can be included in a Snowflake share? Select all that apply.

Tables and views

Dynamic tables

Materialized views

User-defined functions

Submit

18. What command is used to create a share object in Snowflake?

CREATE DATASET

CREATE SHARE

CREATE DATA_EXCHANGE

CREATE COLLABORATION

19. In Snowflake's data sharing model, who bears the compute costs when a reader account queries shared data?

The data provider

The consumer account

Snowflake platform

Shared equally between both

20. Which account type is created specifically to consume shared data without owning Snowflake infrastructure?

Standard account

Reader account

Premium account

Data provider account

SnowPro Advanced Data Sharing Architecture Quiz

1. Which of the following are benefits of using Snowflake data sharing? Select all that apply.

2.

What first name or nickname would you like us to use?

2. Which of the following is a key limitation of Snowflake data sharing?

3. True or False: Provider accounts can track which consumer accounts accessed their shared data.

4. The Snowflake ______ feature enables providers to share data with external organizations via secure links.

5. In Snowflake Marketplace, what is a listing?

6. What is the primary advantage of using a reader account versus a standard consumer account?

7. Which Snowflake role is required to create and manage shares in a provider account?

8. True or False: A consumer account can modify data in shared tables without provider approval.

9. In Snowflake, the ______ feature allows secure data sharing without exposing underlying table structures.

10. What happens to a share when the provider account deletes a shared object?

11. What is the primary purpose of a Snowflake share object in data sharing architecture?

12. True or False: Snowflake shares support real-time data synchronization between provider and consumer accounts.

13. What is the purpose of the GRANT USAGE ON SHARE command?

14. Which system function returns the list of shares available to a consumer account?

15. In Snowflake Marketplace, what role does a provider account play?

16. What is the maximum number of accounts that can consume a single share in Snowflake?

17. Which of the following can be included in a Snowflake share? Select all that apply.

18. What command is used to create a share object in Snowflake?

19. In Snowflake's data sharing model, who bears the compute costs when a reader account queries shared data?

20. Which account type is created specifically to consume shared data without owning Snowflake infrastructure?