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: Nov 14, 2024

Add To Cart

Question 1

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 2

What are characteristics of Dynamic Data Masking? (Select TWO).

A : A masking policy that is currently set on a table can be dropped.

B : A single masking policy can be applied to columns in different tables.

C : A masking policy can be applied to the VALUE column of an external table.

D : The role that creates the masking policy will always see unmasked data in query results.

E : A single masking policy can be applied to columns with different data types.

Answer: B,E

Question 3

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 4

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

A : FALSE

B : TRUE

Answer: B

Question 5

An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not

want to change the main table data. The Administrator decides to

make a transient copy of this table and wants the transient table to have all the same permissions as the

original table How can the Administrator create the transient table so it inherits the same permissions as the original table,

and what considerations need to be made concerning the

requirements? (Select TWO).

A : Use the following SQL command:create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;

B : Use the following SQL command:create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;

C : Use the following SQL commands:create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;

D : Transient tables will persist until explicitly dropped and contribute to overall storage costs.

E : Transient tables will be purged at the end of the user session and do not have any Fail-safe period.

Answer: B,D

Page: 1 / 53

Total 265 Questions | Updated On: Nov 14, 2024

Add To Cart