SnowPro Advanced Administrator ADA-C01

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

  • You have 65 total questions to study from
  • Each page has 5 questions, making a total of 13 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on December 18, 2025
  • 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?
Correct Answer: A

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?
Correct Answer: C

Question 3 of 65
Which authentication methods are available when connecting to Snowflake using the SQL API? (Choose two.)
Correct Answer: A, C

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?
Correct Answer: C

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?
Correct Answer: D