Answer: Micro-partitions

The question asks about the storage unit in Snowflake designed for efficient query processing. Micro-partitions (option D) are the correct answer because Snowflake's architecture uses micro-partitions as the fundamental storage unit that enables features like automatic clustering, partition pruning, and efficient metadata scanning. Micro-partitions are typically 50-500MB compressed and contain metadata that allows Snowflake's query optimizer to skip irrelevant data during query execution. Options A (Blobs), B (JSON), and C (Block storage) are incorrect: Blobs refer to unstructured data storage, JSON is a data format, and block storage is a generic storage concept not specific to Snowflake's query optimization architecture.

Author: LeetQuiz Editorial Team