exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 4 discussion

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

Which of the following roles is recommended to be used to create and manage users and roles?

  • A. SYSADMIN
  • B. SECURITYADMIN
  • C. PUBLIC
  • D. ACCOUNTADMIN
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
blazingliverbird
Highly Voted 3 years, 3 months ago
I think the answer to this should be USERADMIN which is not in the options. So the next best answer will be SECURITYADMIN
upvoted 22 times
...
c0d3g
Highly Voted 2 years, 2 months ago
Selected Answer: B
Here the answer should be SECURITYADMIN as it is parent of USERADMIN (which is the correct answer) More details: https://docs.snowflake.com/en/user-guide/security-access-control-considerations Attention By default, when your account is provisioned, the first user is assigned the ACCOUNTADMIN role. This user should then create one or more additional users who are assigned the USERADMIN role. All remaining users should be created by the user(s) with the USERADMIN role or another role that is granted the global CREATE USER privilege.
upvoted 9 times
...
dbairfan
Most Recent 2 weeks, 1 day ago
Selected Answer: B
Securityadmin is recommended for user management.
upvoted 1 times
...
Yayi123
3 weeks, 5 days ago
Selected Answer: B
SECURITYADMIN
upvoted 1 times
...
PrasantSadangi
1 month ago
Selected Answer: B
Security Admin
upvoted 1 times
...
tharangaweer
2 months, 4 weeks ago
Selected Answer: B
ORGADMIN manages operations at the organizational level ACCOUNTADMIN performs administrative functions SECURITYADMIN creates and manages users and roles, and manages grants USERADMIN creates users and roles SYSADMIN creates and manages databases, schemas, and warehouses PUBLIC is available to all users, but (by default) cannot do anything but log in
upvoted 1 times
...
hotflake
8 months, 4 weeks ago
TYPES OF ROLES: SYSTEM ROLES: ● ORGADMIN manages operations at the organizational level ● ACCOUNTADMIN performs administrative functions ● SECURITYADMIN creates and manages users and roles, and manages grants ● USERADMIN creates users and roles ● SYSADMIN creates and manages databases, schemas, and warehouses ● PUBLIC is available to all users, but (by default) cannot do anything but log in CUSTOM ROLES: ● Created by the SECURITYADMIN or USERADMIN based on a company's desired hierarchy ● Custom roles generally "roll up" to the SYSADMIN role
upvoted 2 times
...
Mallikharjuna452
9 months, 2 weeks ago
B.Securityadmin
upvoted 1 times
...
pranalig
10 months, 2 weeks ago
correct answer:B
upvoted 1 times
...
PrashantGupta1616
10 months, 4 weeks ago
Selected Answer: B
B. SECURITYADMIN The SECURITYADMIN role is specifically designed to handle security-related tasks, including the creation and management of users and roles. This role has the necessary privileges to manage all aspects of user and role administration, which is essential for maintaining a secure and well-managed Snowflake environment.
upvoted 1 times
...
JasMozai
11 months, 4 weeks ago
Selected Answer: B
Security admin: creates and manges users and roles, and manages grants
upvoted 1 times
...
AnireddySaikiranReddy
1 year, 2 months ago
Answer B
upvoted 1 times
...
_yyukta
1 year, 2 months ago
Selected Answer: B
B. SECURITYADMIN
upvoted 1 times
...
engo
1 year, 2 months ago
Selected Answer: B
Answer B
upvoted 1 times
...
Kritig08
1 year, 3 months ago
Selected Answer: B
voted B, parent of USERADMIN
upvoted 1 times
...
Suman_Mondal
1 year, 4 months ago
Selected Answer: B
SECURITYADMIN, parent of USERADMIN
upvoted 1 times
...
KHarish
1 year, 4 months ago
SECURITY ADMIN
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago