U.S. Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake ADA-C01 Exam - Topic 1 Question 56 Discussion

Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?
B) Manage system grants
A) Reset a Snowflake user's password
C) Create new users
D) Create new roles

Snowflake ADA-C01 Exam - Topic 1 Question 56 Discussion

Actual exam question for Snowflake's ADA-C01 exam
Question #: 56
Topic #: 1
[All ADA-C01 Questions]

Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

Show Suggested Answer Hide Answer
Suggested Answer: B

According to the Snowflake documentation1, the SECURITYADMIN role is responsible for managing all grants on objects in the account, including system grants. The USERADMIN role can only create and manage users and roles, but not grant privileges on other objects. Therefore, the function that is unique to the SECURITYADMIN role is to manage system grants. Option A is incorrect because both roles can reset a user's password. Option C is incorrect because both roles can create new users. Option D is incorrect because both roles can create new roles.


Contribute your Thoughts:

0/2000 characters

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


Save Cancel