Snowflake ADA-C02 Actual Free Exam Questions & Community Discussion

Exam Code/Number: ADA-C02
Exam Name/Title: SnowPro Advanced Administrator ADA-C02
Certification Provider: Snowflake
Corresponding Certification: SnowPro Advanced

Exam Questions: 62
Updated On: Jul 20, 2026

Question #1

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

A. Google Cloud Platform (GCP)

B. Custom

C. Okta

D. Duo Security Provisioning Connector

E. Amazon Web Services (AWS)

F. Azure Active Directory (Azure AD)

Discussion 0

Correct Answer: B,C,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #2

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

A. grant role okta_provisioner to role ACCOUNTADMIN;
create or replace security integration okta_provisioning
type = scim
scim_client = 'okta'
run_as_role = 'OKTA PROVISIONER';
Update these steps every 12 months.

B. use role ACCOUNTADMIN;
select system$ generate_scim_access_token ('OKTA PROVISIONING');
Update these steps every 12 months.

C. use role ACCOUNTADMIN;
select system$ generate_scim_access_token ('OKTA PROVISIONING');
Update these steps every 6 months.

D. create or replace security integration okta_provisioning
type = scim
scim_client = 'okta'
run_as_role = 'OKTA PROVISIONER';
Update this step every 6 months.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #3

An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different production tables.
How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

A. Create it as a permanent table with a retention time of 0 days.

B. Create it as an external table, which will not incur Time Travel costs.

C. Create it as a transient table with a retention time of 0 days.

D. Create it as a temporary table with a retention time of 0 days.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #4

A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the time, and occasionally they need three or four clusters of that size.
Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?

A. Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.

B. Create four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run.

C. Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.

D. Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #5

Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

A. Create new roles

B. Manage system grants

C. Reset a Snowflake user's password

D. Create new users

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #6

Which tasks can be performed by the ORGADMIN role? (Choose three.)

A. View a list of all regions enabled for the organization.

B. Create a reader account to share data with another organization.

C. Create one or more accounts in the organization.

D. Perform zero-copy cloning on account data.

E. View usage information for all accounts in the organization.

F. Create secure views on application tables within the organization.

Discussion 0

Correct Answer: A,C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #7

When does auto-suspend occur for a multi-cluster virtual warehouse?

A. After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.

B. Auto-suspend does not apply for multi-cluster warehouses.

C. When the minimum number of clusters is running and there is no activity for the specified period of time.

D. When there has been no activity on any cluster for the specified period of time.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Download Free Snowflake ADA-C02 Demo

Simply submit your e-mail address below to get started with our free demo of your Snowflake ADA-C02 exam.