ExamGecko
Question list
Search
Search

Question 14 - DSA-C02 discussion

Report
Export

Data providers add Snowflake objects (databases, schemas, tables, secure views, etc.) to a share us-ing Which of the following options?

A.
Grant privileges on objects to a share via Account role.
Answers
A.
Grant privileges on objects to a share via Account role.
B.
Grant privileges on objects directly to a share.
Answers
B.
Grant privileges on objects directly to a share.
C.
Grant privileges on objects to a share via a database role.
Answers
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.
Answers
D.
Grant privileges on objects to a share via a third-party role.
Suggested 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.

asked 23/09/2024
Raajhavelu Rengaraj
21 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first