Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam
Go to 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 🗳️
by NachoPrendes at July 19, 2024, 4:01 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
KindleAce
5 days, 11 hours 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 1 times
...
NachoPrendes
4 months 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
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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