Question 1

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

A data provider wants to share data from multiple databases with a data consumer account. How can this be accomplished?

Options :

A :

The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.

B :

The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege on each database referenced by the secure view.

C :

The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share

D :

The data provider needs to create a secure view and must grant the REFERENCE_USAGE privilege on the database where the secure view is created.

Answer: B

Question 4

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

Question 5

What is the correct Precedence for Warehouse Defaults i.e. when a user connects to Snowflake and start a session, In what order Snowflake determines the default warehouse for the session

Options :

A : None of the above is correct

B : 1. .Default warehouse for the user » overridden by… 2. Default warehouse specified on the client command line or through the driver/connector parameters passed to Snowflake » overridden by… 3.. Default warehouse in the configuration file for the client utility (SnowSQL, JDBC driver, etc.)

C : 1.Default warehouse for the user » overridden by… 2. Default warehouse in the configuration file for the client utility (SnowSQL, JDBC driver, etc.) » overridden by… 3. Default warehouse specified on the client command line or through the driver/connector parameters passed to Snowflake

D : 1. Default warehouse in the configuration file for the client utility (SnowSQL, JDBC driver, etc.) » overridden by 2. … Default warehouse for the user » overridden by… 3. Default warehouse specified on the client command line or through the driver/connector parameters passed to Snowflake

Answer: C

Confidently Practice Online with Free ADA-C01 Exam Cram

Buying Options: