Question 1

Snowflake does not provide which of following set of SQL functions to support retrieving infor-mation about tasks?

Options :

A : SYSTEM$CURRENT_USER_TASK_NAME

B : TASK_HISTORY

C : TASK_DEPENDENTS

D : TASK_QUERY_HISTORY

E : SYSTEM$TASK_DEPENDENTS_ENABLE

Answer: C

Question 2

Which system table will you use to get the total credit consumption over a specific time period?

Options :

A : WAREHOUSE_METERING_HISTORY

B : WAREHOUSE_CREDIT_USAGE_HISTORY

C : WAREHOUSE_USAGE_HISTORY

Answer: A

Question 3

Search optimization is a table-level property and applies to all columns with supported data types

Options :

A : TRUE

B : FALSE

Answer: A

Question 4

Clones can be cloned, with no limitations on the number or iterations of clones that can be created (e.g. you can create a clone of a clone of a clone, and so on), which results in a n-level hierarchy of cloned objects, each with their own portion of shared and independent data storage?

Options :

A : TRUE

B : FALSE

C :

Answer: A

Question 5

The smaller the average depth, the better clustered the table is with regards to the specified column?

Options :

A : TRUE

B : FALSE

Answer: A

Free DEA-C02 Mock Exam – Practice Online Confidently

Buying Options: