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 02, 2024

Add To Cart

Question 1

As Administrator you have created Custom Role CR1 & this CR1 Roles user are from Billing Department of Company & required SnowFlake Account usage & billing information access, how are you going to enable users who are not account administrators to access/view usage and billing information in this case?

A : Non Account Admin Role cannot query Billing & Usage information as this is not allowed

B : Grant IMPORTED PRIVILEGES on database SNOWFLAKE to query all of the ACCOUNT USAGE views

C : CR1 Role can be granted MONITOR USAGE privilege

D : User can be granted OPERATE Privilege

Answer: B,C

Question 2

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

Question 3

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 4

When future grants are defined at both the database and schema level, the schema level grants take precedence over the database level grants, and the database level grants are ignored.?

A : FALSE

B : TRUE

Answer: B

Question 5

If a view references any object in another database (e.g. table columns, other views, UDFs, or stages), both databases must be replicated during database replication?