Design Account and Role Architecture ARA-C01 Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   When should an organization consider creating a custom role instead of using a built-in role in Snowflake?

   • AWhen the organization wants to avoid managing role hierarchies.
   • BWhen the organization wants to reduce the number of roles in the system.
   • CWhen the organization wants to use a role that cannot be granted to users.
   • DWhen the built-in roles do not provide the exact set of privileges needed for a specific job function.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Why is it important to establish organizational conventions for role naming?

   • ATo ensure that roles are named consistently, making them easier to identify and manage.
   • BTo reduce the number of roles that need to be created.
   • CTo make it harder for unauthorized users to guess role names.
   • DTo comply with Snowflake's mandatory naming requirements.
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which of the following is an example of an account-level privilege in Snowflake?

   • AUSAGE on a schema
   • BSELECT on a table
   • CCREATE WAREHOUSE
   • DINSERT on a view
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A financial company requires that the user who approves a data load job cannot be the same user who executes the load. The company uses Snowflake tasks and stored procedures. What is the most appropriate way to enforce this separation of duties?

   • AGrant the ACCOUNTADMIN role to all users involved in the data load process.
   • BCreate a single role with EXECUTE on both the task and the stored procedure, and assign all users to it.
   • CUse a single role for all users and rely on the task's schedule to enforce the separation.
   • DCreate two roles: APPROVER with EXECUTE on the task and EXECUTOR with EXECUTE on the stored procedure. Assign users to only one role.
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   What is a recommended practice for naming roles in Snowflake?

   • AUse names that include the user's name for personalization.
   • BUse names that reflect the job function or purpose of the role.
   • CUse random alphanumeric strings to avoid conflicts.
   • DUse the same name for all roles to simplify.
   Reveal Solution Discussion Select an answer first