SnowPro Core (COF-C03) — Practice Exam

Snowflake's micro-partitions are foundational to its query performance and storage model. Which statement about micro-partitions is correct?

• A.Their size is user-configurable between 16 MB and 256 MB at table creation time.
• B.They are immutable once created — DML operations produce new micro-partitions and mark old ones for the Fail-Safe lifecycle.
• C.A single micro-partition can span multiple tables to enable efficient cross-table scans.
• D.They are held in the compute layer rather than the storage layer for performance.