SnowPro Advanced Administrator ADA-C02

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

  • You have 55 total questions across 11 pages (5 per page)
  • These questions were last updated on March 18, 2026
  • This site is not affiliated with or endorsed by Snowflake.
Question 1 of 55

What steps are required to set up OKTAAPI token integration in Snowflake?
Answer

Suggested Answer

The suggested answer is D.

Question 2 of 55

A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.
An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.
What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Choose two.)
Answer

Suggested Answer

The suggested answer is C, D.

Question 3 of 55

Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?
Answer

Suggested Answer

The suggested answer is A.

Question 4 of 55

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?
Answer

Suggested Answer

The suggested answer is A.

Question 5 of 55

What SCIM integration types are supported in Snowflake? (Choose three.)
Answer

Suggested Answer

The suggested answer is C, D, E.

About the Snowflake SnowPro Advanced Administrator ADA-C02 Certification Exam

About the Exam

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

How to Prepare

Work through all 55 practice questions across 11 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 ADA-C02 questions are regularly updated to reflect the latest exam objectives.