Discuss Snowflake ARA-R01 Exam Topic 2 Question 42

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

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.

SHOW GRANTS

Understanding Access Control in Snowflake

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

33 comments · newest first

William 5 days ago

I feel option A makes more sense. Ownership is key.

Yolando 10 days ago

I think it's option B. Grants are important.

Eleonore 15 days ago

D is confusing. Grants and ownership are mixed up.

Isaiah 20 days ago

C seems right. Roles matter in Snowflake.

Delmy 26 days ago

I feel like A makes sense too. Ownership is key.

Lonna 1 month ago

I think it's option B. Grants are important.

Viola 1 month ago

I feel like Command 1 is about grants, not ownership.

Virgina 1 month ago

I prefer option B. It makes more sense to me.

Lilli 2 months ago

Yeah, but Command 2 seems to focus on ownership.

Marge 2 months ago

I think Command 1 shows grants to Marge.

Georgene 2 months ago

Command 1 is about grants, not ownership. Just saying!

Cammy 2 months ago

Wait, can Command 1 really show grants? Sounds off.

Amie 2 months ago

Definitely agree with option B!

Lanie 2 months ago

I think Command 2 is about ownership, not grants.

Luisa 3 months ago

Command 1 shows grants to user_01, not ownership.

Sheridan 3 months ago

Command 1 is about grants, but I’m not convinced about the rest.

Sharita 3 months ago

Wait, are we sure about that? Sounds off to me.

Marla 3 months ago

Definitely B, that makes the most sense!

Tamie 3 months ago

I think Command 2 is about ownership, not grants.

Arlyne 3 months ago

Command 1 shows grants to user_01, not ownership.

Lovetta 4 months ago

I’m leaning towards C, seems to fit the commands better.

Eliz 5 months ago

Definitely not A, that’s not how ownership works in Snowflake.

Penney 5 months ago

Wait, can Command 2 really show ownership? Sounds off.

Rosita 5 months ago

I think B is correct! Grants are what matters here.

Julene 6 months ago

Command 1 shows grants to user_01, not ownership.

Kasandra 6 months ago

I thought Command 1 was about roles, but now I'm second-guessing myself. I need to review the differences between grants and ownership again.

Kaycee 6 months ago

I feel like Command 1 is definitely about grants, but I’m confused about what Command 2 does. Maybe it’s about ownership?

Truman 6 months ago

I think both commands are about grants, but I can't recall which one shows ownership. It feels like a practice question we did.

Wilda 6 months ago

I remember that "show grants to user" is supposed to show the privileges assigned to a user, but I'm not sure about the second command.

Detra 6 months ago

I feel like Command 1 is about grants, but I’m confused about Command 2. I thought it was about ownership, but it could be roles too.

Elenora 7 months ago

From what I studied, Command 1 should show all the grants given to user_01, but I can't recall if Command 2 is about ownership or roles.

Tashia 7 months ago

I remember practicing a similar question, and I think Command 1 is definitely about grants. Command 2 might be about ownership too, but I'm not 100% certain.

Leanora 7 months ago

I think Command 1 shows the grants for user_01, but I'm not sure what Command 2 does exactly. It might be about ownership?

Snowflake ARA-R01 Exam - Topic 2 Question 42 Discussion