Question 1

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 2

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

Options :

A : FALSE

B : TRUE

Answer: B

Question 3

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 4

What are the requirements when creating a new account within an organization in Snowflake? (Select TWO).

Options :

A : The account requires at least one ORGADMIN role within one of the organization-s accounts.

B : The account name is immutable and cannot be changed.

C : The account name must be specified when the account is created.

D : The account name must be unique among all Snowflake customers.

E : The account name must be unique within the organization.

Answer: C,E

Question 5

What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

Options :

A : Any role with GRANT USAGE on SECURITY INTEGRATION

B : ACCOUNTADMIN and SYSADMIN

C : ACCOUNTADMIN and SECURITYADMIN

D : ACCOUNTADMIN only

Answer: D

Free ADA-C01 Mock Exam – Practice Online Confidently