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

An Administrator needs to configure a virtual warehouse in Snowflake for a new use case with these details:
1. There will be 50-100 concurrent users running reports
2. Minimize costs based on the number of active users at a given time
3. The virtual warehouse should suspend and resume automatically based on user activity
Which configuration will meet these requirements?

A. create or replace warehouse reporting_wh
warehouse_size = xxxlarge
max_cluster_count = 10
scaling_policy = standard
auto_suspend = 600
auto_resume = false;

B. create or replace warehouse reporting_wh
warehouse_size = medium
auto_suspend = 600
auto_resume = true;

C. create or replace warehouse reporting_wh
warehouse_size = medium
max_cluster_count = 10
scaling_policy = standard
auto_suspend = 600
auto_resume = true;

D. create or replace warehouse reporting_wh
warehouse_size = xxxlarge
auto_suspend = 60
auto_resume = true;

Discussion 0

Correct Answer: C Vote an answer

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

Question #16

What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?

A. Database: Usage
Schema: Usage
Table: Select

B. Database: Usage, Create Stream
Schema: Usage
Table: Select

C. Database: Usage
Schema: Usage, Create Stream
Table: Select

D. Database: Usage
Schema: Usage
Table: Select, Create Stream

Discussion 0

Correct Answer: C Vote an answer

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

Question #17

A company has implemented Snowflake replication between two Snowflake accounts, both of which are running on a Snowflake Enterprise edition. The replication is for the database APP_DB containing only one schema, APP_SCHEMA. The company's time Travel retention policy is currently set for 30 days for both accounts. An Administrator has been asked to extend the time Travel retention policy to 60 days on the secondary database only.
How can this requirement be met?

A. Set the data retention policy on the schemas in the secondary database to 60 days.

B. Set the data retention policy on the secondary database to 60 days.

C. Set the data retention policy on the primary database to 30 days and the schemas to 60 days.

D. Set the data retention policy on the primary database to 60 days.

Discussion 0

Correct Answer: D Vote an answer

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

Question #18

What are characteristics of data replication in Snowflake? (Choose three.)

A. Replication can only occur within the same cloud provider.

B. The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.

C. Users must be granted REPLICATIONADMIN privileges in order to enable replication.

D. Databases created from shares can be replicated.

E. To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.

F. Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization.

Discussion 0

Correct Answer: B,D,E Vote an answer

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

Question #19

A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directional synchronization for user identities. An Administrator with access to SECURITYADMIN uses the Snowflake UI to create a user by issuing the following commands:
use role USERADMIN;
create or replace role DEVELOPER_ROLE;
create user PTORRES PASSWORD = 'hello world!' MUST_CHANGE_PASSWORD = FALSE
default_role = DEVELOPER_ROLE;
The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. When attempted, the following command fails:
use DEVELOPER_ROLE;
Why does this command fail?

A. USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.

B. The new role can only take effect after USERADMIN has logged out.

C. The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role.

D. The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account.

Discussion 0

Correct Answer: A Vote an answer

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

Question #20

What is the default data retention period for transient databases, schemas, and tables for Snowflake Enterprise edition and higher?

A. 30 days

B. 90 days

C. 1 day

D. 14 days

Discussion 0

Correct Answer: C Vote an answer

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

Question #21

What is required for stages, without credentials, to limit data exfiltration after a storage Integration and associated stages are created?

A. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = true;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = false;

B. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = false;

C. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true;

D. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = true;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true;

Discussion 0

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