
Answer-first summary for fast verification
Answer: More control over object-level access for different user groups
The correct answer is C because database roles provide more granular control over object-level access for different user groups. When using database roles, you can create multiple roles within a shared database and grant specific privileges to each role, allowing different consumer accounts or user groups to access only the subsets of shared objects they need. This is more flexible than directly granting privileges to a share, which provides the same access to all consumer accounts. The community discussion confirms this advantage, noting that shared database roles allow different groups of users to access different subsets of shared objects. Option A is incorrect because cross-region data sharing management is not directly related to database roles. Option B is incorrect because including objects from multiple databases is handled through shares themselves, not database roles. Option D is incorrect because database roles don't necessarily reduce the number of shares required; they provide finer access control within shared databases.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is a benefit of utilizing database roles rather than directly granting privileges on objects to a share in Snowflake?
A
Easier management of cross-region data sharing
B
Greater flexibility in including objects from multiple databases
C
More control over object-level access for different user groups
D
Reduction in the number of shares required for different objects in the same database