Question 1

If the Account Administrator granted global CREATE DATA EXCHANGE LISTING privilege to a role, the role can be used to perform which of the following tasks?

Options :

A : Reject listing requests

B : Submit listings for approval/publishing listings

C : Create and view provider profiles

D : Modify listings properties

Answer: A,B,C,D

Question 2

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

Options :

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

Select correct statements with respect to replication operation

Options :

A : The individual row access policies cannot be replicated

B : Policy-protected objects can be replicated if they are in the same database as the policy

C : The replication operation fails if A table or view contained in the primary database has a reference to a row access policy in a different database

D : The replication operation fails if the primary database is in an Enterprise (or higher) account and contains a policy but one or more of the accounts approved for replication are on lower editions

Answer: B,C,D

Question 4

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

Options :

A : FALSE

B : TRUE

Answer: B

Question 5

As an Administrator, you are looking out for information which can help to determine whether the organizationâ€™s active user population which should be provisioned into Snowflake matches the users provisioned into Snowflake. Which Information schema table function can help you to provide this auditing?

Options :

A : REST_EVENT_HISTORY

B : EVENT_HISTORY

C : SCIM_API_EVENT_HISTORY

D : REST_API_EVENT_HISTORY

Answer: A

Confidently Practice Online with Free ADA-C01 Exam Cram

Buying Options: