Answer: Privileges are only inherited by the direct parent role in the hierarchy.

The correct answer is C based on Snowflake's documented role hierarchy and privilege inheritance model. In Snowflake, when roles are granted to other roles, privileges are inherited upward in the hierarchy - specifically, a role inherits all privileges from roles granted to it (its child roles). This means privileges flow from child roles to parent roles, not downward or sideways. Option A is incorrect because privileges are not inherited by 'any roles above' indiscriminately - only by direct parent roles in the chain. Option B is wrong as there's no inheritance between roles at the same level. Option D is incorrect because privileges flow upward to parent roles, not downward to child roles. The community discussion strongly supports C with 60% consensus and multiple comments citing Snowflake documentation confirming that privileges are inherited by parent roles in the hierarchy.

Author: LeetQuiz Editorial Team