Here are all the actual test exam dumps for IT exams. Most people prepare for the actual exams with our test dumps to pass their exams. So it's critical to choose and actual test pdf to succeed.

Exam COF-C02 Topic 2 Question 498 Discussion

Actual exam question for Snowflake's COF-C02 exam
Question #: 498
Topic #: 2
Which commands will indicate if Multi-Factor Authentication, or MFA, has been enabled for a given user?
Select TWO.

Suggested Answer: A,B Vote an answer

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.

by Christopher at May 01, 2026, 09:54 PM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.