Question 1

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 2

Snowflake computes and adds partitions based on the defined partition column expressions when an external table metadata is refreshed. What are the Correct Statements to configure Partition metadata refresh in case of External Tables?

Options :

A : By default, the metadata is refreshed automatically when the object is created.

B : The object owner can configure the metadata to refresh automatically when new or updated data files are available in the external stage.

C : Metadata refresh is not required as its Managed implicitly by Snowflake.

D : Partitions of External tables is managed by External Stage Cloud provider.

E : There is nothing like adding partitions on External tables.

Answer: A,B

Question 3

Snowflake does not treat the inner transaction as nested; instead, the inner transaction is a separate transaction. What is term used to call these Transaction?

Options :

A : Scoped transactions

B : Inner Transaction

C : Nested Scope Transaction

D : Atomic Transaction

E : Enclosed Transaction

Answer: A

Question 4

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

Options :

A : TRUE

B : FALSE

Answer: A

Question 5

If using a JavaScript UDF in a masking policy, Data Engineer needs to ensure the data type of the column, UDF, and masking policy match irrespective of case-sensitivity?

Options :

A : TRUE

B : FALSE

Answer: B

Higher Test Marks with Free Online DEA-C02 Exam Practice

Buying Options: