SnowPro Core Certification — Question 264

What SQL command would be used to view all roles that were granted to USER1?

Answer options

• A. show grants to user USER1;
• B. show grants user USER1;
• C. describe user USER1;
• D. show grants on user USER1;

Correct answer: A

Explanation

The correct answer is A, as 'show grants to user USER1;' is the proper syntax to display the roles granted to a specific user in SQL. Options B and D are incorrect because they lack the correct syntax, and option C is not suitable as 'describe user USER1;' is typically used to show user details, not granted roles.