SOL-C01 practice question 25 of 30
What is the purpose of a role hierarchy in Snowflake?
Full set: 214 questionsA role hierarchy is created in Snowflake by granting one role to another. The fundamental purpose of this is to enable privilege inheritance. A role that is granted another role (the "parent") inherits all the privileges of the role that was granted to it (the "child"). This allows for the creation of composite roles from more granular ones, simplifying the management of complex permission schemes and promoting the principle of least privilege without redundant grant statements.
A. To define the sequence of SQL queries: The execution order of SQL queries is determined by application logic or the user, not by the role hierarchy.
C. To manage network settings: Network access controls, such as IP address whitelisting, are managed through Network Policies, not role hierarchies.
D. To store raw data: Roles are security principals for managing access. Raw data is stored in database objects like tables.
- Snowflake Documentation: Role Hierarchy and Privilege Inheritance. The section states, "Roles can be granted to other roles, creating a role hierarchy. The privileges granted to a role are inherited by any roles above that role in the hierarchy."
Keep practicing
Take the free SOL-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SOL-C01 practice questions
- Question 1Which Snowflake object is a logical container for schemas and other database objects?
- Question 2How can Python variable substitution be performed in Snowflake notebooks?
- Question 3Which SQL command is commonly used to load structured data from a stage into a Snowflake …
- Question 4Which command can be used to query the Information Schema in Snowflake to retrieve a list…
- Question 5Which command is synonymous with the LIST command in Snowflake?
- Question 6Which of the following data format supported to unload semi-structured data from Snowflak…
