A Snowflake administrator is tasked with setting up role-based access control (RBAC) to manage access to different objects within Snowflake using the web UI. Which of the following statements accurate

Question

Options

• ARoles can only be created and managed using SQL commands within a worksheet and cannot be
• BThe Snowflake web UI allows creating custom roles, granting privileges to these roles, and
• CRole hierarchies cannot be created through the web UI; they must be defined using SQL
• DThe 'Account' section in the Snowflake web UI provides a visual interface to manage users, roles,
• EThe web UI only allows granting ownership of database objects to roles but not individual

• A
  2% (1)
• B
  90% (37)
• C
  2% (1)
• E
  5% (2)

Explanation

Option B is accurate: Snowsight's web UI provides forms and interfaces to create custom roles, assign privileges to those roles on specific database objects, and assign roles to users-without needing to write SQL. Option D is accurate: the Account section in Snowsight contains dedicated pages for managing Users, Roles, and Privileges with a visual interface, supporting full RBAC administration. Option A is false-roles can absolutely be created and managed through the web UI, not just via SQL worksheets. Option C is false-role hierarchies (granting one role to another) can be configured through the UI's role management pages. Option E is false-the web UI supports granting a variety of privileges (SELECT, INSERT, USAGE, etc.) on objects, not just ownership.

No community discussion yet for this question.