Question 45

Explanation

✅ Privilege inheritance
✅ Database roles
✅ Functional roles compared to access roles

Explanation:

Snowflake’s Role-Based Access Control (RBAC) model is designed to manage user permissions efficiently by assigning privileges to roles rather than individual users. The key components include:

• Privilege inheritance → Roles can be granted to other roles, creating a hierarchical structure where privileges are inherited.

• Database roles → Roles can be assigned at the database level, controlling access to schemas, tables, and other database objects.

• Functional roles vs. access roles → Functional roles define job-specific permissions, while access roles manage data access and security.

For more details, check the official Snowflake documentation on RBAC.

❌ Why the other option is incorrect?

System roles are not supported in Snowflake
→ Incorrect, because Snowflake does have system-defined roles like ACCOUNTADMIN, SECURITYADMIN, and SYSADMIN, which provide administrative control over various aspects of the platform.