nerdexam
SnowflakeSnowflake

DEA-C02 · Question #59

DEA-C02 Question #59: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #59. The question stem and answer options stay visible for context.

Performance Optimization

Question

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?

Options

  • ASELECT SYSTEM$CLUSTERING_INFORMATION('Invoice');
  • BSELECT $CLUSTERING_INFORMATION('Invoice');
  • CCALL SYSTEM$CLUSTERING_INFORMATION('Invoice');
  • DCALL $CLUSTERING_INFORMATION('Invoice');

Unlock DEA-C02 to see the answer

You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Micro-partitions#Clustering Information#System Functions#Table Metadata
Full DEA-C02 PracticeBrowse All DEA-C02 Questions