Exam COF-C03 Topic 1 Question 107 Discussion

The correct answers are A. SHOW USERS and B. DESCRIBE USER .
Snowflake user metadata includes information related to MFA enrollment and configuration. To inspect user- level properties, administrators can use SHOW USERS or DESCRIBE USER.
Why A is correct:
SHOW USERS returns information about users in the account. Its output can include user properties that indicate MFA status or related authentication details.
Why B is correct:
DESCRIBE USER returns detailed properties for a specific user. This can be used to inspect whether MFA has been enabled for that user.
Example:
DESCRIBE USER my_user;
Why the other options are incorrect:
C). SHOW PARAMETERS displays parameters, not user MFA enrollment status.
D). SHOW USER FUNCTIONS lists user-defined functions, not Snowflake users.
E). SHOW CONNECTIONS displays connection objects and does not indicate MFA status for a specific user.
Official Snowflake documentation reference:
Snowflake documentation describes SHOW USERS and DESCRIBE USER as commands for viewing user metadata and user properties.
Reference: Snowflake Documentation - SHOW USERS; DESCRIBE USER; Multi-Factor Authentication; SnowPro Core Study Guide - Security and Access Control.
==