Not sure whether 2Pass4sure is worth it? As of 2026, you can still download a free demo of the ADA-C02 practice questions and judge the quality of the Snowflake SnowPro Advanced Administrator ADA-C02 material yourself before spending a cent.

Snowflake ADA-C02 Exam Overview:

Snowflake ADA-C02 Exam Syllabus Topics:

Snowflake ADA-C02 Exam: Everything You Wanted to Ask

Snowflake SnowPro Advanced Administrator ADA-C02 Sample Questions:

Question 1

A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business-Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Choose two.)

A. Increase the minimum number of clusters started in the multi-cluster configuration to 5.
B. Increase the multi-cluster maximum to 20 or more clusters.
C. Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.
D. Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.
E. Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.

Question 2

A user with the proper role issues the following commands when setting up and activating network policies:
CREATE OR REPLACE NETWORK POLICY foo_policy
ALLOWED_IP_LIST = ('1.1.1.0/24', '2.2.2.0/24', '3.3.3.0/24')
BLOCKED_IP_LIST = ('1.1.1.1')
COMMENT = 'Account level policy';
ALTER ACCOUNT SET NETWORK_POLICY=foo_policy;
CREATE OR REPLACE NETWORK POLICY bar_policy
ALLOWED_IP_LIST = ('3.3.3.0/24')
BLOCKED_IP_LIST = ('3.3.3.10')
COMMENT = 'user level policy';
ALTER USER user1 SET NETWORK_POLICY=BAR_POLICY;
Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.
Will the login be successful?

A. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.
B. No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.
C. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.
D. No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.

Question 3

What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)

A. Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.
B. Resource monitors can be applied to more than one virtual warehouse.
C. Multiple resource monitors can be applied to a single virtual warehouse.
D. Multiple triggers can be configured across various virtual warehouse thresholds.
E. The cost of running a resource monitor is only 10% of a credit, per day of operation.
F. Resource monitors add no additional load to virtual warehouse compute.

Question 4

An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that contains multiple secure views. The Administrator would like to configure the data so that only certain roles can see certain secure views.
How can this be accomplished?

A. Create views over the incoming shared database and apply the desired RBAC onto these views.
B. Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables.
C. Individually grant imported privileges onto the schema in the share.
D. Apply RBAC directly onto the partner's shared secure views.

Question 5

What are benefits of using Snowflake organizations? (Choose two.)

A. Administrators have the ability to create accounts in any available cloud provider or region.
B. Administrators can change Snowflake account editions on-demand based on need.
C. Administrators can simplify data movement across all accounts within the organization.
D. Administrators can monitor and understand usage across all accounts in the organization.
E. User administration is simplified across all accounts within the organization.

Solutions: