Question 1

What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO).

Options :

A : SYSADMIN

B : SECURITYADMIN

C : ACCOUNTADMIN

D : IMPORT SHARE and CREATE DATABASE

E : IMPORT PRIVILEGES and SHARED DATABASE

Answer: C,D

Question 2

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?

Options :

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 3

What are known benefits of TAGS in Snowflake?

Options :

A : Enable Data Optimization

B : Sensitive Data Tracking and Resource Usage

C : EASE of Use & Tag Lineage

D : To facilitate compliance with internal and external regulatory requirements

E : Micro Partition Management

F : Consistent Assignment with Replication

Answer: A,B,C,D

Question 4

Operating on a masking policy requires the USAGE privilege on the parent database and schema?

Options :

A : TRUE

B : FALSE

Answer: A

Question 5

A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the time, and occasionally they need three or four clusters of that size. Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?

Options :

A :

Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.

B :

Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.

C :

Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.

D :

Create four virtual warehouses (sized Small through XL) and set them to auto-suspend andauto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run

Answer: B

Higher Test Marks with Free Online ADA-C01 Exam Practice

Buying Options: