Answer-first summary for fast verification
Answer: SELECT on the specific tables in the database., USAGE on the database and the schema containing the tables to share.
To share data in Snowflake, the provider must grant two types of privileges: SELECT on the specific tables to allow the consumer to query the data, and USAGE on both the database and schema containing those tables to provide access to the database and schema objects. Option C (SELECT on specific tables) is necessary for data access, and option D (USAGE on database and schema) is required for the consumer to reference the objects. Options A and B are incorrect because USAGE on tables or MODIFY privileges are not needed for data sharing. Option E is incorrect as OPERATE is not a valid privilege for this context. The community discussion consistently supports C and D with 100% consensus and references official Snowflake documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When sharing data in Snowflake, which two privileges must a provider grant on the objects included in a share?
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.
No comments yet.