Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake COF-R02 Exam - Topic 6 Question 75 Discussion

What is a best practice after creating a custom role?
B) Assign the custom role to the SYSADMIN role
A) Create the custom role using the SYSADMIN role.
C) Assign the custom role to the PUBLIC role
D) Add__CUSTOM to all custom role names

Snowflake COF-R02 Exam - Topic 6 Question 75 Discussion

Actual exam question for Snowflake's COF-R02 exam
Question #: 75
Topic #: 6
[All COF-R02 Questions]

What is a best practice after creating a custom role?

Show Suggested Answer Hide Answer
Suggested Answer: B

When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.


Contribute your Thoughts:

0/2000 characters

Currently there are no comments in this discussion, be the first to comment!


Save Cancel