Question 1

Snowflake web interface can be used to create users with no passwords or remove passwords from existing users?

Options :

A : TRUE

B : FALSE

Answer: B

Question 2

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

Question 3

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 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

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

Higher Test Marks with Free Online ADA-C01 Exam Practice

Buying Options: