SnowPro Core Certification — Question 819

How are privileges inherited in a role hierarchy in Snowflake?

Answer options

• A. Privileges are inherited by any roles above that role in the hierarchy.
• B. Privileges are inherited by any roles at the same level in the hierarchy.
• C. Privileges are only inherited by the direct parent role in the hierarchy.
• D. Privileges are only inherited by the direct child role in the hierarchy.

Correct answer: A

Explanation

The correct answer is A because in Snowflake, roles inherit privileges from all roles that are above them in the hierarchy, allowing for a cascading effect of permissions. Options B, C, and D are incorrect as they misrepresent the inheritance structure, either limiting the inheritance to the same level or only to direct relationships.