DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #25
In which of the following file formats is data from Delta Lake tables primarily stored?
The correct answer is C. Parquet. Delta Lake stores its actual data in Parquet format, a columnar binary file format known for efficient compression and fast analytical query performance. Delta Lake adds a transaction log (the _delta_log directory containing JSON and checkpoint files) on top of Parquet to…
Question
Options
- ADelta
- BCSV
- CParquet
- DJSON
- EA proprietary, optimized format specific to Databricks
How the community answered
(46 responses)- A7% (3)
- C89% (41)
- D2% (1)
- E2% (1)
Explanation
Delta Lake stores its actual data in Parquet format, a columnar binary file format known for efficient compression and fast analytical query performance. Delta Lake adds a transaction log (the _delta_log directory containing JSON and checkpoint files) on top of Parquet to provide ACID transactions, schema enforcement, and time travel. 'Delta' is the table format/protocol layer, not a file storage format. CSV and JSON are row-oriented text formats, and Delta Lake does not use a proprietary binary format.
Topics
Community Discussion
No community discussion yet for this question.