What SQL command would be used to view all roles that were granted to user.1?
A . show grants to user USER1;
B . show grants of user USER1;
C . describe user USER1;
D . show grants on user USER1;
Answer: A
Explanation:
The correct command to view all roles granted to a specific user in Snowflake is SHOW GRANTS TO USER <user_name>;. This command lists all access control privileges that have been explicitly granted to the specified user.
Reference: SHOW GRANTS | Snowflake Documentation
Latest COF-C02 Dumps Valid Version with 254 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund