COF-C02 Question #602: Real Exam Question with Answer & Explanation

Question

Which access control entity in Snowflake can be created as part of a hierarchy within an account?

Options

• ASecurable object
• BRole
• CPrivilege
• DUser

Explanation

In Snowflake, a role is an access control entity that can be created as part of a hierarchy within an account. Roles are used to grant and manage privileges in a structured and scalable manner. Understanding Roles: Roles are logical entities that group privileges together. They are used to control access to securable objects like tables, views, warehouses, and more. Roles can be organized into a hierarchy, allowing for the inheritance of privileges. A role higher in the hierarchy (parent role) can grant its privileges to a lower role (child role), simplifying privilege Roles can be created using the CREATE ROLE command. You can define parent-child relationships by granting one role to another. CREATE ROLE role1; CREATE ROLE role2; GRANT ROLE role1 TO role2; In this example, role2 inherits the privileges of role. Simplifies privilege management: Hierarchies allow for efficient privilege assignment and Enhances security: Roles provide a clear structure for managing access control, ensuring that privileges are granted appropriately.

No community discussion yet for this question.