SnowPro Advanced: Architect — Question 103

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?

Answer options

• 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

Correct answer: D

Explanation

The correct answer is D because 'show grants to user user_01' displays all the privileges granted to user_01, while 'show grants on user user_01' indicates which role owns user_01. The other options misinterpret the purpose of these commands regarding ownership and grants.