Free Practice Snowflake ADA-C01 Exam Questions 2026

Stay ahead with 100% Free SnowPro Advanced Administrator ADA-C01 Dumps Practice Questions

Page: 1 / 56

Total 278 Questions | Updated On: Feb 19, 2026

Add To Cart

Question 1

The maximum number of unique tag keys that can be set on a single object is

A : 100

B : 10

C : 50

D : 20

Answer: D

Question 2

What are characteristics of data replication in Snowflake? (Select THREE).

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

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

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

D : Replication can only occur within the same cloud provider.

E : Databases created from shares can be replicated.

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.

Answer: A,E,F

Question 3

What is the correct Precedence for Warehouse Defaults i.e. when a user connects to Snowflake and start a session, In what order Snowflake determines the default warehouse for the session

A : None of the above is correct

B : 1. .Default warehouse for the user » overridden by…2. Default warehouse specified on the client command line or through the driver/connector parameters passed to Snowflake » overridden by…3.. Default warehouse in the configuration file for the client utility (SnowSQL, JDBC driver, etc.)

C : 1.Default warehouse for the user » overridden by…2. Default warehouse in the configuration file for the client utility (SnowSQL, JDBC driver, etc.) » overridden by…3. Default warehouse specified on the client command line or through the driver/connector parameters passed to Snowflake

D : 1. Default warehouse in the configuration file for the client utility (SnowSQL, JDBC driver, etc.) » overridden by2. … Default warehouse for the user » overridden by…3. Default warehouse specified on the client command line or through the driver/connector parameters passed to Snowflake

Answer: C

Question 4

Snowflake data providers can share data with data consumers in a different region?

A : FALSE

B : TRUE

Answer: B

Question 5

Select true statement with respect to API Integration..

A : Your Snowflake account can have multiple API integration objects

B : Only Snowflake roles with OWNERSHIP or USAGE privileges on the API integration can use the API integration directly

C : Multiple external functions can use the same API integration object, and thus the same HTTPS proxy service

D : An API integration object is tied to a specific cloud platform account and role within that account.

Answer: A,B,C,D

Page: 1 / 56

Total 278 Questions | Updated On: Feb 19, 2026

Add To Cart