Question

A data engineer is explaining Snowflake's Database Storage layer to a new team member. The team member asks how table data is physically organized once loaded. Which statement accurately describes how Snowflake stores table data in this layer?

Accepted Answer

Data is automatically divided into immutable, compressed, columnar micro-partitions managed entirely by Snowflake.

Answer

Data is stored in fixed-size 1 GB row-oriented blocks that users can manually update in place.

Answer

Data is held in the virtual warehouse's local SSD cache and persists only while the warehouse is running.

Answer

Data is stored as plain-text CSV files in a user-managed external stage bucket by default.