Valid DEA-C01 Dumps shared by ExamDiscuss.com for Helping Passing DEA-C01 Exam! ExamDiscuss.com now offer the newest DEA-C01 exam dumps, the ExamDiscuss.com DEA-C01 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DEA-C01 dumps with Test Engine here:
Which output is provided by both theSYSTEM$CLUSTERING_DEPTHfunction and theSYSTEM$CLUSTERING_INFORMATIONfunction?
Correct Answer: A
Explanation The output that is provided by both the SYSTEM$CLUSTERING_DEPTH function and the SYSTEM$CLUSTERING_INFORMATION function is average_depth. This output indicates the average number of micro-partitions that contain data for a given column value or combinationof column values. The other outputs are not common to both functions. The notes output is only provided by the SYSTEM$CLUSTERING_INFORMATION function and it contains additional information or recommendations about the clustering status of the table. The average_overlaps output is only provided by the SYSTEM$CLUSTERING_DEPTH function and it indicates the average number of micro-partitions that overlap with other micro-partitions for a given column value or combination of column values. The total_partition_count output is only provided by the SYSTEM$CLUSTERING_INFORMATION function and it indicates the total number of micro-partitions in the table.
