SOL-C01 Question #266: Real Exam Question with Answer & Explanation

Question

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 accurately describe best practices and functionalities available through the Snowflake web UI for managing RBAC?

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

Explanation

The Snowflake web UI enables creating custom roles, granting various privileges (including object privileges like SELECT and INSERT), and assigning roles to users or other roles. The 'Account' section within the web UI indeed provides a user- friendly interface for managing users, roles, and their associated privileges. Role hierarchies can be managed through SQL but the UI also allows users to manage, by assigning users or roles to a given role. Therefore, 'C' is incorrect. 'A' is incorrect as roles can be managed by using the UI.

No community discussion yet for this question.