When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).

The correct answer is A. USAGE on the specific tables in the database. D. USAGE on the database and the schema containing the tables to share. To share data with a consumer account, a provider must grant two levels of privilege: (1) USAGE on the database and the schema that contain the tables - this allows the consumer to navigate the object hierarchy - and (2) SELECT on the specific tables being shared - this grants…

Data Protection and Data Sharing

Question

Options

AUSAGE on the specific tables in the database.
BUSAGE on the specific tables in the database.
CMODIFY on 1Mb specific tables in the database.
DUSAGE on the database and the schema containing the tables to share
EOPEBATE on the database and the schema containing the tables to share.

How the community answered

(53 responses)

A
94% (50)
B
2% (1)
E
4% (2)

Explanation

To share data with a consumer account, a provider must grant two levels of privilege: (1) USAGE on the database and the schema that contain the tables - this allows the consumer to navigate the object hierarchy - and (2) SELECT on the specific tables being shared - this grants read access to the actual data. Note: Choice A in this question appears to contain a typo (says USAGE instead of SELECT on tables); the intended privilege is SELECT. MODIFY and OPERATE are not required for sharing, as consumers only need read access.

Topics

#Data Sharing#Provider Privileges#USAGE Grant#Access Control

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice