Free Snowflake ADA-C01 Exam Questions

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

Page: 1 / 56

Total 278 Questions | Updated On: Sep 11, 2025

Add To Cart

Question 1

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

A : SYSADMIN

B : SECURITYADMIN

C : ACCOUNTADMIN

D : IMPORT SHARE and CREATE DATABASE

E : IMPORT PRIVILEGES and SHARED DATABASE

Answer: C,D

Question 2

What are known benefits of TAGS in Snowflake?

A : Enable Data Optimization

B : Sensitive Data Tracking and Resource Usage

C : EASE of Use & Tag Lineage

D : To facilitate compliance with internal and external regulatory requirements

E : Micro Partition Management

F : Consistent Assignment with Replication

Answer: A,B,C,D

Question 3

In case of Query Result Cache reuse requirements, Changes can be made to source tables, but only if they do not affect any micro-partitions relevant to query?

A : TRUE

B : FALSE

Answer: A

Question 4

Snowflake web interface can be used to create users with no passwords or remove passwords from existing users?

A : TRUE

B : FALSE

Answer: B

Question 5

Enable failover for a primary database to one or more accounts in your organization using which command?

A : ALTER DATABASE … ENABLE FAILOVER TO ACCOUNT

B : It can be set only via SnowSight web interface

C : ALTER DATABASE … ENABLE FAILOVER TO ACCOUNTS

D : ALTER DATABASE … ACTIVATE FAILOVER TO ACCOUNTS

Answer: C

Page: 1 / 56

Total 278 Questions | Updated On: Sep 11, 2025

Add To Cart