SnowPro Advanced: Architect — Question 70

What is a characteristic of Role-Based Access Control (RBAC) as used in Snowflake?

Answer options

• A. Privileges can be granted at the database level and can be inherited by all underlying objects.
• B. A user can use a "super-user" access along with SECURITYADMIN to bypass authorization checks and access all databases, schemas, and underlying objects.
• C. A user can create managed access schemas to support future grants and ensure only schema owners can grant privileges to other roles.
• D. A user can create managed access schemas to support current and future grants and ensure only object owners can grant privileges to other roles.

Correct answer: C

Explanation

The correct answer, C, highlights the ability to create managed access schemas specifically for future grants while ensuring only schema owners have the authority to grant privileges. Option A is incorrect as it doesn't mention the specific limitations on granting privileges, while B incorrectly describes bypassing authorization checks, and D focuses on current grants rather than future ones.