SnowPro Advanced: Data Engineer — Question 54

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?

Answer options

• A. SELECT SYSTEM$CLUSTERING_INFORMATION('Invoice');
• B. SELECT $CLUSTERING_INFORMATION('Invoice');
• C. CALL SYSTEM$CLUSTERING_INFORMATION('Invoice');
• D. CALL $CLUSTERING_INFORMATION('Invoice');

Correct answer: A

Explanation

The correct answer is A, as SYSTEM$CLUSTERING_INFORMATION is the appropriate built-in function to retrieve the micro-partition layout for the specified table. Options B, C, and D are incorrect because B omits the SYSTEM prefix, while C and D incorrectly use the CALL statement instead of SELECT for this function.