Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 280 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 280
Topic #: 1
[All SnowPro Core Questions]

What is a best practice after creating a custom role?

  • A. Create the custom role using the SYSADMIN role.
  • B. Assign the custom role to the SYSADMIN role.
  • C. Assign the custom role to the PUBLIC role.
  • D. Add _CUSTOM to all custom role names.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
SnowProCertDec22
Highly Voted 1 year, 11 months ago
answer is B Custom roles (i.e. any roles other than the system-defined roles) can be created by the USERADMIN role (or a higher role) as well as by any role to which the CREATE ROLE privilege has been granted. By default, a newly-created role is not assigned to any user, nor granted to any other role. 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.
upvoted 9 times
...
Mallikharjuna452
Most Recent 3 months, 4 weeks ago
B Represents correct answer
upvoted 1 times
...
_yyukta
8 months, 3 weeks ago
Selected Answer: B
B. Assign the custom role to the SYSADMIN role.
upvoted 1 times
...
Marge23
1 year, 2 months ago
Selected Answer: B
SYSADMIN (aka System Administrator) Role that has privileges to create warehouses and databases (and other objects) in an account. If, as recommended, you create a role hierarchy that ultimately assigns all custom roles to the SYSADMIN role, this role also has the ability to grant privileges on warehouses, databases, and other objects to other roles.
upvoted 1 times
...
singhks
1 year, 3 months ago
Selected Answer: B
B is the right answer
upvoted 1 times
...
MultiCloudIronMan
1 year, 4 months ago
Selected Answer: B
Correct
upvoted 1 times
...
EmiB
1 year, 8 months ago
Selected Answer: B
B. Assign the custom role to the SYSADMIN role.
upvoted 2 times
...
miadiesel
1 year, 11 months ago
Selected Answer: B
https://docs.snowflake.com/en/user-guide/security-access-control-overview.html#role-hierarchy-and-privilege-inheritance https://docs.snowflake.com/en/user-guide/security-access-control-overview.html#role-hierarchy-and-privilege-inheritance
upvoted 4 times
...
harshagc180
1 year, 11 months ago
Answer A https://docs.snowflake.com/en/user-guide/security-access-control-overview.html#
upvoted 1 times
harshagc180
1 year, 10 months ago
Sorry, correct answer is B
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...