Exam SOL-C01 Topic 1 Question 75 Discussion
Actual exam question for Snowflake's SOL-C01 exam
Question #: 75
Topic #: 1
Question #: 75
Topic #: 1
What is the purpose of assigning roles to users in Snowflake?
Suggested Answer: A Vote an answer
Snowflake uses a Role-Based Access Control (RBAC) model, whererolesare the containers of privileges.
Assigning roles to users ensures that permissions on database objects (such as tables, schemas, warehouses, and functions) are enforced consistently and securely. Users do not receive privileges directly; instead, privileges are granted to roles, and roles are assigned to users.
This enables scalable, auditable, and manageable access control.
Roles do not determine tasks, do not affect query optimization, and do not govern which data types a user may query-permissions are object-based, not datatype-based.
Assigning roles to users ensures that permissions on database objects (such as tables, schemas, warehouses, and functions) are enforced consistently and securely. Users do not receive privileges directly; instead, privileges are granted to roles, and roles are assigned to users.
This enables scalable, auditable, and manageable access control.
Roles do not determine tasks, do not affect query optimization, and do not govern which data types a user may query-permissions are object-based, not datatype-based.
by Moira at Dec 25, 2025, 03:43 PM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).