SOL-C01 practice question 30 of 30
What is the purpose of assigning roles to users in Snowflake?
Full set: 214 questionsSnowflake uses Role-Based Access Control (RBAC) as its core security model. The purpose of roles is to act as containers for privileges (permissions) on securable objects like databases, tables, and warehouses. Privileges are granted to roles, and roles are then granted to users or other roles. This model simplifies security administration by allowing administrators to manage sets of permissions collectively rather than assigning them to each user individually. Assigning a role to a user grants them all the privileges associated with that role.
B. Roles grant permissions to perform tasks, but they do not define the tasks themselves. Snowflake Tasks are a separate object.
C. Access control roles do not influence the query optimizer's logic for creating execution plans.
D. Permissions are granted on objects (like tables or columns), not on specific data types.
1. Snowflake Documentation. (n.d.). Overview of Access Control. Retrieved from https://docs.snowflake.com/en/user-guide/security-access-control-overview. "Access control privileges are granted to roles, which are in turn assigned to users... All access control in Snowflake is managed through roles."
2. Snowflake Documentation. (n.d.). Access Control in Snowflake. Retrieved from https://docs.snowflake.com/en/user-guide/security-access-control. "In the Snowflake model, access to securable objects is allowed via privileges assigned to roles, which are in turn assigned to other roles or users."
3. Snowflake Documentation. (n.d.). Configuring Access Control. Retrieved from https://docs.snowflake.com/en/user-guide/security-access-control-configure. "Step 3: Grant privileges on database objects to the role." This section explicitly details the process of assigning permissions to roles.
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…
