SnowPro Core Certification — Question 1010
How is role hierarchy established in Snowflake?
Answer options
- A. By assigning users to roles
- B. By default when a role is created
- C. By granting one role to another role
- D. By transferring ownership of one role to another role
Correct answer: C
Explanation
The correct answer is C, as role hierarchy in Snowflake is created by granting one role to another, allowing permissions to be inherited. Option A is incorrect because while users are assigned to roles, it does not establish hierarchy. Option B is misleading since roles do not automatically create a hierarchy without such grants. Option D is wrong because ownership transfer does not create a hierarchy.