Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 1074

How is role hierarchy established in Snowflake?

By assigning users to roles

By default when a role is created

By granting one role to another role

By transferring ownership of one role to another role

Correct Answer: C

In Snowflake, a role hierarchy is established by granting one role to another role. This action creates a parent-child relationship between the roles, where the granted role becomes a 'child' and inherits permissions from the 'parent' role, effectively creating the hierarchy.

Discussion

Jacobr5000Option: C

"Granting a role to another role creates a “parent-child” relationship between the roles (also referred to as a role hierarchy)."

NachoPrendesOption: C

C https://docs.snowflake.com/en/sql-reference/sql/grant-role#:~:text=GRANT%20ROLE-,GRANT%20ROLE,-Assigns%20a%20role