Which of the following options?

Data providers add Snowflake objects (databases, schemas, tables, secure views, etc.) to a share using.

Which of the following options?
A . Grant privileges on objects to a share via Account role.
B . Grant privileges on objects directly to a share.
C . Grant privileges on objects to a share via a database role.
D . Grant privileges on objects to a share via a third-party role.

View Answer

Answer: B, C

Explanation:

What is a Share?

Shares are named Snowflake objects that encapsulate all of the information required to share a database.

Data providers add Snowflake objects (databases, schemas, tables, secure views, etc.) to a share using either or both of the following options:

Option 1: Grant privileges on objects to a share via a database role.

Option 2: Grant privileges on objects directly to a share.

You choose which accounts can consume data from the share by adding the accounts to the share. After a database is created (in a consumer account) from a share, all the shared objects are accessible to users in the consumer account.

Shares are secure, configurable, and controlled completely by the provider account:

・ New objects added to a share become immediately available to all consumers, providing real-time access to shared data.

Access to a share (or any of the objects in a share) can be revoked at any time.