DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #60
Which of the following describes the storage organization of a Delta table?
The correct answer is C. Delta tables are stored in a collection of files that contain data, history, metadata, and other. A Delta table is physically stored as a collection of Parquet files (the actual data, often partitioned) combined with a _delta_log transaction log directory containing JSON and checkpoint files that store metadata, schema, history, and other attributes. This multi-file…
Question
Options
- ADelta tables are stored in a single file that contains data, history, metadata, and other attributes.
- BDelta tables store their data in a single file and all metadata in a collection of files in a separate
- CDelta tables are stored in a collection of files that contain data, history, metadata, and other
- DDelta tables are stored in a collection of files that contain only the data stored within the table.
- EDelta tables are stored in a single file that contains only the data stored within the table.
How the community answered
(55 responses)- B7% (4)
- C87% (48)
- D4% (2)
- E2% (1)
Explanation
A Delta table is physically stored as a collection of Parquet files (the actual data, often partitioned) combined with a _delta_log transaction log directory containing JSON and checkpoint files that store metadata, schema, history, and other attributes. This multi-file structure is what enables Delta Lake's ACID transactions, time travel, and schema enforcement. Option A and E are wrong because Delta tables are never a single file. Option B is partially correct but wrong in calling data a 'single file.' Option D is wrong because it omits metadata and history, which are central to what makes Delta Lake different from plain Parquet.
Topics
Community Discussion
No community discussion yet for this question.