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: Jan 10, 2025

Add To Cart

Question 1

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 2

A user created column level security using dynamic data masking policy in one of the column & then later on applied row level access policy in another column, which one of type of access policies snowflake evaluates first in order to provide security of data?

A : Row access policy evaluates first

B : Snowflake does not support both type of policy at the same time

C : Timing does not matter here, individual column level security i.e. dynamic data masking will evaluates first & applied

D : Dynamic data masking first as its applied before

Answer: A

Question 3

Once an account is created, ORGADMIN can view the account properties but does not have access to the account data?

A : FALSE

B : TRUE

Answer: B

Question 4

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 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 / 53

Total 265 Questions | Updated On: Jan 10, 2025

Add To Cart