A company wants to design a role hierarchy where the ANALYST role can query tables in the SALES schema, and the MANAGER role should have all ANALYST privileges plus the ability to create tables. What is the best practice for this hierarchy?

Grant both roles the same privileges on the SALES schema.

Grant the MANAGER role directly to users and ANALYST to other users.

Create ANALYST as a child role of MANAGER and grant CREATE TABLE to ANALYST.

Create MANAGER as a child role of ANALYST and grant CREATE TABLE on the SALES schema to MANAGER.

A company has a complex role hierarchy with multiple levels. The security team wants to simplify the hierarchy by reducing the number of roles. They propose merging two roles, ROLE_A and ROLE_B, into a single role ROLE_C. ROLE_A is a parent of ROLE_B. What is the best approach?

Create ROLE_C with all privileges of ROLE_A and ROLE_B, then grant ROLE_C to all users who had ROLE_A or ROLE_B, and drop ROLE_A and ROLE_B.

Rename ROLE_A to ROLE_C and grant ROLE_C to all users who had ROLE_B.

Drop ROLE_B and grant ROLE_A to all users who had ROLE_B.

Create ROLE_C as a child of ROLE_A and grant ROLE_C to all users who had ROLE_B.

A company wants to implement a role design where the DATA_ANALYST role is used by all analysts, and the SENIOR_ANALYST role should have all the privileges of DATA_ANALYST plus the ability to create views. What is the best practice for this design?

Create SENIOR_ANALYST as a child role of DATA_ANALYST and grant CREATE VIEW to SENIOR_ANALYST.

Create DATA_ANALYST as a child role of SENIOR_ANALYST and grant CREATE VIEW to DATA_ANALYST.

Grant SENIOR_ANALYST to DATA_ANALYST.

Grant both roles the same privileges.

Which SQL command is used to grant the SELECT privilege on a table to a role in Snowflake?

GRANT SELECT ON my_table TO my_role

GRANT SELECT ON TABLE my_table TO ROLE my_role

ALLOW SELECT ON my_table TO my_role

PERMIT SELECT ON TABLE my_table TO ROLE my_role

SnowPro® Core Certification

Domain 3Objective 1

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

Part of the Account Management and Data Governance domain, which accounts for 20% of the COF-C03 exam.

22questions here

5free pages

5concepts

20%of the exam

Questions 11–15

11application · medium
A company wants to design a role hierarchy where the ANALYST role can query tables in the SALES schema, and the MANAGER role should have all ANALYST privileges plus the ability to create tables. What is the best practice for this hierarchy?
Select an answer first
12foundation · easy
Which SQL command assigns a role to a user in Snowflake?
Select an answer first
13expert · hard
A company has a complex role hierarchy with multiple levels. The security team wants to simplify the hierarchy by reducing the number of roles. They propose merging two roles, ROLE_A and ROLE_B, into a single role ROLE_C. ROLE_A is a parent of ROLE_B. What is the best approach?
Select an answer first
14application · medium
A company wants to implement a role design where the DATA_ANALYST role is used by all analysts, and the SENIOR_ANALYST role should have all the privileges of DATA_ANALYST plus the ability to create views. What is the best practice for this design?
Select an answer first
15foundation · easy
Which SQL command is used to grant the SELECT privilege on a table to a role in Snowflake?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to COF-C03

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “COF-C03” is a trademark of its owner, used for identification only.