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., ========================]
Submit