Data Engineer, ran the below clustering depth analysis function:
select system$clustering_depth('TPCH_CUSTOMERS', '(C1, C6)', 'C9 = 30'); on TPCH_CUSTOMERS table, will return which of the following?

Question

Data Engineer, ran the below clustering depth analysis function:select system$clustering_depth('TPCH_CUSTOMERS', '(C1, C6)', 'C9 = 30'); on TPCH_CUSTOMERS table, will return which of the following?

Thuy Nguyen · Accepted Answer

Calculate the clustering depth for a table using mentioned columns in the table.

Thuy Nguyen · Answer

An error: this function does not accept lists of columns as a third parameter.

Thuy Nguyen · Answer

An error: this function does not accept predicates ('C9 = 30') as parameter.

Thuy Nguyen · Answer

Calculate the clustering depth for a table using the clustering key defined for the table.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 43 - DEA-C01 discussion

Suggested answer: C

0 comments