All data in Snowflake tables is automatically divided into micro-partitions, which are what?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

All data in Snowflake tables is automatically divided into micro-partitions, which are what?

Explanation:
Micro-partitions are the basic storage unit Snowflake uses internally. They are contiguous chunks of table data, stored in a columnar and compressed format. Each partition is immutable and carries metadata (like min and max values for each column) that lets Snowflake prune data during query execution, so only partitions that might contain the result are scanned. They are not geographic shards, not index pages, and not data frames.

Micro-partitions are the basic storage unit Snowflake uses internally. They are contiguous chunks of table data, stored in a columnar and compressed format. Each partition is immutable and carries metadata (like min and max values for each column) that lets Snowflake prune data during query execution, so only partitions that might contain the result are scanned. They are not geographic shards, not index pages, and not data frames.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy