Which statement best describes micro-partitions?

• A. Contiguous storage units
• B. Geographic shards
• C. Index pages
• D. Data frames

Answer: (A)

Micro-partitions are the basic storage unit Snowflake uses to organize table data. Each one is a small, contiguous block of columnar data stored on disk, created as data is loaded and then kept immutable. Snowflake stores metadata for each micro-partition (like min/max values and row counts) so the engine can prune out partitions that don’t match a query’s predicates, which makes searches faster. They aren’t geographic shards, they aren’t index pages, and they aren’t data frames. So the best description is that micro-partitions are contiguous storage units.