SnowPro Core Certification — Question 1043

What is an advantage of using database roles instead of granting privileges on objects directly to a share in Snowflake?

Answer options

• 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

Correct answer: C

Explanation

The correct answer, C, indicates that using database roles allows for more precise management of access to individual objects based on user group needs. The other options, while they may suggest benefits, do not directly relate to the primary advantage of granular control over object-level permissions which is the essence of using roles.