SnowPro Advanced Administrator ADA-C01

Here you have the best Snowflake SnowPro Advanced Administrator practice exam questions

You have 65 total questions across 13 pages (5 per page)
These questions were last updated on February 16, 2026
This site is not affiliated with or endorsed by Snowflake.

Question 1 of 65

A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening.
Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?

Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.

Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.

Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.

Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.

Question 2 of 65

Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?

Exam SnowPro Advanced Administrator: Question 2 - Image 1

Exam SnowPro Advanced Administrator: Question 2 - Image 2

Exam SnowPro Advanced Administrator: Question 2 - Image 3

Exam SnowPro Advanced Administrator: Question 2 - Image 4

Question 3 of 65

Which authentication methods are available when connecting to Snowflake using the SQL API? (Choose two.)

Question 4 of 65

The following SQL command was executed:
Exam SnowPro Advanced Administrator: Question 4 - Image 1

Which role(s) can alter or drop table XYZ?

Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.

SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.

PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.

Only the PROD_WORKING_OWNER role can alter or drop table XYZ.

Question 5 of 65

The following commands were executed:
Grant usage on database PROD to role PROD_ANALYST;
Grant usage on database PROD to role PROD_SUPERVISOR;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;
Grant role PROD_ANALYST to user A;
Grant role PROD_SUPERVISOR to user B;
What authority does each user have on the WORKING schema?

Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.

Tables created by either user A or user B will be visible to both users.

All existing tables in schema PROD.WORKING will be visible to both users.

Both user A and user B can create tables in the PROD.WORKING schema.

About the Snowflake SnowPro Advanced Administrator Certification Exam

About the Exam

The Snowflake SnowPro Advanced Administrator (SnowPro Advanced Administrator ADA-C01) validates your knowledge and skills. Passing demonstrates proficiency and can boost your career prospects in the field.

How to Prepare

Work through all 65 practice questions across 13 pages. Focus on understanding the reasoning behind each answer rather than memorizing responses to be ready for any variation on the real exam.

Why Practice Exams?

Practice exams help you familiarize yourself with the question format, manage your time, and reduce anxiety on the test day. Our SnowPro Advanced Administrator questions are regularly updated to reflect the latest exam objectives.