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

- Free Preparation Discussions

Snowflake Exam ARA-R01 Topic 4 Question 30 Discussion

Actual exam question for Snowflake's ARA-R01 exam

Question #: 30
Topic #: 4

[All ARA-R01 Questions]

A new user user_01 is created within Snowflake. The following two commands are executed:

Command 1-> show grants to user user_01;

Command 2 ~> show grants on user user 01;

What inferences can be made about these commands?

ACommand 1 defines which user owns user_01
Command 2 defines all the grants which have been given to user_01

BCommand 1 defines all the grants which are given to user_01 Command 2 defines which user owns user_01

CCommand 1 defines which role owns user_01
Command 2 defines all the grants which have been given to user_01

DCommand 1 defines all the grants which are given to user_01
Command 2 defines which role owns user 01

Show Suggested Answer

Suggested Answer: D

The SHOW GRANTS command in Snowflake can be used to list all the access control privileges that have been explicitly granted to roles, users, and shares.The syntax and the output of the command vary depending on the object type and the grantee type specified in the command1. In this question, the two commands have the following meanings:

Command 1: show grants to user user_01; This command lists all the roles granted to the user user_01. The output includes the role name, the grantee name, and the granted by role name for each grant.This command is equivalent to show grants to user current_user if user_01 is the current user1.

Command 2: show grants on user user_01; This command lists all the privileges that have been granted on the user object user_01. The output includes the privilege name, the grantee name, and the granted by role name for each grant.This command shows which role owns the user object user_01, as the owner role has the privilege to modify or drop the user object2.

Therefore, the correct inference is that command 1 defines all the grants which are given to user_01, and command 2 defines which role owns user_01.

Understanding Access Control in Snowflake

by Page at Mar 19, 2025, 08:18 AM

Limited Time Offer

25%

Off

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Janine

3 days ago

I see your point, but I still think B is the correct answer because Command 2 should show all the grants given to user_01.

upvoted 0 times

...

Leigha

3 days ago

Haha, I bet the person who wrote this question is a big Snowflake fan. But seriously, I think Option D is the correct answer. Gotta love those SQL commands!

upvoted 0 times

...

Harrison

7 days ago

I think A makes more sense because Command 1 should define the owner of user_01.

upvoted 0 times

...

Solange

9 days ago

Wait, so Command 1 defines the owner of user_01, and Command 2 defines the grants? I'm a bit confused, but I think Option C is the way to go.

upvoted 0 times

...

Dalene

12 days ago

Command 1 shows the grants given to user_01, while Command 2 shows the grants on the user user_01. Seems straightforward to me.

upvoted 0 times

Charlette

1 hours ago

A) Command 1 defines which user owns user_01

upvoted 0 times

...

...

Blair

15 days ago

I disagree, I believe the correct answer is B.

upvoted 0 times

...

Miles

23 days ago

I think the correct answer is A.

upvoted 0 times

...