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 #8

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

A. User administration is simplified across all accounts within the organization.

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 have the ability to create accounts in any available cloud provider or region.

E. Administrators can monitor and understand usage across all accounts in the organization.

Discussion 0

Correct Answer: D,E Vote an answer

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

Question #9

If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

A. No, because the materialized view may not be up-to-date.

B. No, because joins are not supported by materialized views.

C. No, because the optimizer might decide against it.

D. Yes, because materialized views are always faster.

Discussion 0

Correct Answer: C Vote an answer

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

Question #10

In general, the monthly billing for database replication is proportional to which variables? (Choose two.)

A. The number and size of warehouses defined in the primary account

B. The frequency of the secondary database refreshes from the primary database

C. The amount of table data in the primary database that changes as a result of data loading or DML operations

D. The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts

E. The frequency of changes to the primary database as a result of data loading or DML operations

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #11

What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Choose two.)

A. SYSADMIN

B. IMPORT PRIVILEGES and SHARED DATABASE

C. IMPORT SHARE and CREATE DATABASE

D. SECURITYADMIN

E. ACCOUNTADMIN

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #12

What are the requirements when creating a new account within an organization in Snowflake? (Choose two.)

A. The account name must be unique among all Snowflake customers.

B. The account name must be specified when the account is created.

C. The account name must be unique within the organization.

D. The account name is immutable and cannot be changed.

E. The account requires at least one ORGADMIN role within one of the organization's accounts.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #13

What information is required from the Identity Provider (IdP) to enable federated authentication in Snowflake? (Choose two.)

A. Authentication certificate

B. IdP encryption key

C. IdP account details

D. URL endpoint for SAML requests

E. SAML response format

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #14

Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Choose two.)

A. GRANT ROLE ORGADMIN TO USER <username>;

B. SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('ACCOUNT_LOCATOR','ENABLE_ACCOUNT_DATABASE_REPLICATION','true');

C. SHOW USERS;

D. SHOW REGIONS;

E. SHOW ORGANIZATION ACCOUNTS;

Discussion 0

Correct Answer: D,E 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.