Exam SnowPro Advanced Architect topic 1 question 109 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 109
Topic #: 1

[All SnowPro Advanced Architect 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?

A. Command 1 defines which user owns user_01
Command 2 defines all the grants which have been given to user_01
B. Command 1 defines all the grants which are given to user_01
Command 2 defines which user owns user_01
C. Command 1 defines which role owns user_0l
Command 2 defines all the grants which have been given to user_01
D. Command 1 defines all the grants which are given to user_01
Command 2 defines which role owns user_01

Show Suggested Answer

Suggested Answer: C 🗳️

by NachoPrendes at July 19, 2024, 4:01 p.m.

Comments

Submit Cancel

Arkitekt

3 months, 1 week ago

Selected Answer: D

Command 1: show grants to user user_01; This command lists all the roles granted to the user user_01. Command 2: show grants on user user_01; This command lists all the privileges that have been granted on the user object user_01. https://docs.snowflake.com/en/sql-reference/sql/show-grants

upvoted 3 times

...

KindleAce

9 months, 1 week ago

SHOW GRANTS TO USER user_01: Lists all the roles granted to the user_01. SHOW GRANTS ON USER user_01: Lists all privileges granted to the user user_01.

upvoted 3 times

...

NachoPrendes

1 year, 1 month ago

Selected Answer: C

Checked on Snowflake https://docs.snowflake.com/en/sql-reference/sql/show-grants#:~:text=the%20demo%20user%3A-,SHOW%20GRANTS%20TO%20USER,-demo%3B%0A%0A%2B

upvoted 3 times

...