
Answer-first summary for fast verification
Answer: Can SHOW users DESCRIBE a given user, or ALTER or DROP a user
The correct answer is A because the ACCOUNTADMIN role in Snowflake can perform specific user management operations: SHOW USERS (to list all users), DESCRIBE USER (to view details of a specific user), ALTER USER (to modify user properties), and DROP USER (to delete a user). The community discussion, including upvoted comments and references to Snowflake documentation, confirms that only these operations are valid. Option B is incorrect because DEFINE and DELETE are not valid user commands (DROP is used instead of DELETE). Option C is wrong as INDEX is not a user-related command. Option D is incorrect because DEFINE and MODIFY are not standard user management commands (ALTER covers modifications).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following commands can a user with the ACCOUNTADMIN role execute on existing user accounts?
A
Can SHOW users DESCRIBE a given user, or ALTER or DROP a user
B
Can DEFINE users, DESCRIBE a given user, or ALTER or DELETE a user
C
Can SHOW users, INDEX a given user, or ALTER or DELETE a user
D
Can SHOW users, DEFINE a given user or ALTER, DROP, or MODIFY a user
No comments yet.