Manage Roles and Role-Based Access Control COF-C03 Practice Questions (Page 2)

Questions 6–10

1. 6application · easy

   A new analyst, Priya, joins the marketing team. The MARKETING_ANALYST role already exists and has SELECT privileges on the MARKETING schema. You need to grant Priya access to the marketing data. What should you do?

   • ACreate a new role for Priya and grant it SELECT on the MARKETING schema.
   • BGrant SELECT on the MARKETING schema directly to Priya.
   • CAlter the MARKETING_ANALYST role to add Priya as a user.
   • DGrant the MARKETING_ANALYST role to Priya.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A user with the ACCOUNTADMIN role wants to grant the ANALYST role the ability to create schemas in the ANALYTICS database. What is the correct command?

   • AGRANT CREATE SCHEMA ON DATABASE ANALYTICS TO ROLE ANALYST;
   • BGRANT USAGE ON DATABASE ANALYTICS TO ROLE ANALYST;
   • CGRANT ALL PRIVILEGES ON DATABASE ANALYTICS TO ROLE ANALYST;
   • DALTER DATABASE ANALYTICS SET OWNER TO ROLE ANALYST;
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   What is the ownership privilege in Snowflake?

   • AA privilege that grants full control over an object, including the ability to grant privileges on it to other roles.
   • BA privilege that only allows viewing the object's metadata.
   • CA privilege that allows only data manipulation, not schema changes.
   • DA privilege that is automatically granted to all roles in the hierarchy.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which SQL command is used to create a new role in Snowflake?

   • AADD ROLE
   • BDEFINE ROLE
   • CCREATE ROLE
   • DNEW ROLE
   Reveal Solution Discussion Select an answer first
6. 10application · easy

   A developer accidentally granted the PUBLIC role the INSERT privilege on the SALES table. You need to remove this privilege immediately. What should you do?

   • ARun REVOKE ALL ON SALES FROM ROLE PUBLIC;
   • BRun DROP ROLE PUBLIC;
   • CRun ALTER TABLE SALES SET INSERT = FALSE;
   • DRun REVOKE INSERT ON SALES FROM ROLE PUBLIC;
   Reveal Solution Discussion Select an answer first