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

You have just created a table in snowflake. There are now rows in the table. What will be the clustering depth of the table?

Options :

A : 0

B : 1

C : 2

Answer: A

Question 3

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

Options :

A : TRUE

B : FALSE

Answer: A

Question 4

Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset, what will be the value of METADATA$ISUPDATE Columns in this scenario?

Options :

A : TRUE

B : FALSE

C : UPDATE

D : INSERT

Answer: B

Question 5

Streams cannot be created to query change data on which of the following objects? [Select All that Apply]

Options :

A : Standard tables, including shared tables.

B : Views, including secure views

C : Directory tables

D : Query Log Tables

E : External tables

Answer: D

Free SnowPro-Advanced-Data-Engineer Mock Exam – Practice Online Confidently

Buying Options: