SnowPro Core Certification — Question 1084

When sharing data in Snowflake, what privileges does a Provider need to grant along with a share? (Choose two.)

Answer options

• A. USAGE on the specific tables in the database.
• B. MODIFY on the specific tables in the database.
• C. SELECT on the specific tables in the database.
• D. USAGE on the database and the schema containing the tables to share.
• E. OPERATE on the database and the schema containing the tables to share.

Correct answer: C, D

Explanation

The correct answer includes 'SELECT on the specific tables in the database' and 'USAGE on the database and the schema containing the tables to share' because these permissions are necessary for the receiver to access the shared data. Options B and E are incorrect as MODIFY and OPERATE privileges are not required for data sharing in this context.