Which statement about micro-partition properties used to optimize queries is correct?

• A. Additional properties used for optimization and efficient query processing.
• B. Micro-partitions do not include any metadata.
• C. Micro-partitions store only the numeric values.
• D. Micro-partitions store only the data values, not metadata.

Answer: (A)

Micro-partitions carry metadata that supports query optimization. Each micro-partition stores not only the data but also properties like min and max values for each column and a row count. These statistics (often called zone maps) let the query engine quickly determine which partitions could contain matching rows and skip the rest, reducing I/O and speeding up processing. That’s why the description of micro-partitions including additional properties used for optimization and efficient query processing is the correct interpretation. The other statements are inconsistent with how micro-partitions work because they imply metadata isn’t stored or that only data values are kept.