Free Snowflake ADA-C01 Exam Questions

Become Snowflake Certified with updated ADA-C01 exam questions and correct answers

Page: 1 / 53

Total 265 Questions | Updated On: Jul 30, 2025

Add To Cart

Question 1

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

Question 2

Auto-resume only applies when the entire warehouse is suspended (i.e. no clusters are running)

A : FALSE

B : TRUE

Answer: B

Question 3

Which one is not the Usage schema contained by SNOWFLAKE database?

A : ORGANIZATION_USAGE

B : READER_ACCOUNT_USAGE

C : DATA_SHARING_USAGE

D : CONSUMER_ACCOUNT_USAGE

E : ACCOUNT_USAGE

Answer: D

Question 4

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 5

Operating on a masking policy requires the USAGE privilege on the parent database and schema?

A : TRUE

B : FALSE

Answer: A

Page: 1 / 53

Total 265 Questions | Updated On: Jul 30, 2025

Add To Cart