exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam

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 Hide Answer
Suggested Answer: D 🗳️

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
KindleAce
1 month, 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 2 times
...
NachoPrendes
5 months, 1 week 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 2 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