SnowPro Advanced Data Engineer Exam

Exam SnowPro Advanced Data Engineer All QuestionsBrowse all questions from this exam

Question 59

A Data Engineer needs to know the details regarding the micro-partition layout for a table named Invoice using a built-in function.

Which query will provide this information?

SELECT SYSTEM$CLUSTERING_INFORMATION('Invoice');

SELECT $CLUSTERING_INFORMATION('Invoice');

CALL SYSTEM$CLUSTERING_INFORMATION('Invoice');

CALL $CLUSTERING_INFORMATION('Invoice');

Correct Answer: A

To obtain the micro-partition layout details for a table named Invoice, you should use the built-in function SYSTEM$CLUSTERING_INFORMATION. The correct query format for this is SELECT SYSTEM$CLUSTERING_INFORMATION('Invoice');. This function provides clustering information for a specified table, including details on its micro-partitions.

Discussion

stopthisnowOption: A

SYSTEM$CLUSTERING_INFORMATION Returns clustering information, including average clustering depth, for a table based on one or more columns in the table.