Each micro partition contains between 50 MB and 500 MB of uncompressed data.

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

Each micro partition contains between 50 MB and 500 MB of uncompressed data.

Explanation:
Micro-partitions are the basic storage units Snowflake uses to hold table data. Each partition stores a chunk of data that is typically between 50 MB and 500 MB of uncompressed data. Even though this data is stored on disk in compressed form, the cited range refers to the uncompressed size. This sizing is a design target that helps Snowflake manage metadata, enable efficient pruning, and keep partition-level statistics useful for fast query pruning. In practice, you’ll see data sizes that generally fall within this range, though exact sizes can vary slightly based on data types and nulls. That’s why the statement is considered correct: it reflects the common, guideline-based size range Snowflake uses for micro-partitions.

Micro-partitions are the basic storage units Snowflake uses to hold table data. Each partition stores a chunk of data that is typically between 50 MB and 500 MB of uncompressed data. Even though this data is stored on disk in compressed form, the cited range refers to the uncompressed size. This sizing is a design target that helps Snowflake manage metadata, enable efficient pruning, and keep partition-level statistics useful for fast query pruning. In practice, you’ll see data sizes that generally fall within this range, though exact sizes can vary slightly based on data types and nulls. That’s why the statement is considered correct: it reflects the common, guideline-based size range Snowflake uses for micro-partitions.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy