Question 1

Column level security feature includes

Options :

A : ROW ACCESS POLICIES

B : EXTERNAL TOKENIZATION

C : DYNAMIC DATA MASKING

D : SECURE VIEW

Answer: B,C

Question 2

The maximum number of unique tag keys that can be set on a single object is

Options :

A : 100

B : 10

C : 50

D : 20

Answer: D

Question 3

What are characteristics of data replication in Snowflake? (Select THREE).

Options :

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

SQL to view the amount of replication data transferred (in bytes) for your Snowflake account within a specified date range can be queried using which of the Views/Table functions

Options :

A : REPLICATION_USAGE_HISTORY table function (in the Snowflake Information Schema).

B : REPLICATION_METERING_HISTORY View view (in Account Usage)

C : REPLICATION_USAGE_HISTORY View view (in Account Usage)

D : REPLICATION_METERING_HISTORY table function (in the Snowflake Information Schema)

Answer: A,C

Question 5

Select true statement with respect to API Integration..

Options :

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

Smartly Prepare Exam with Free Online ADA-C01 Practice Test

Buying Options: