Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Which of the following describes the storage organization of a Delta table?
Real Exam
Community
KKeng
A
Delta tables are stored in a single file that contains data, history, metadata, and other attributes.
B
Delta tables store their data in a single file and all metadata in a collection of files in a separate location.
C
Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.
D
Delta tables are stored in a collection of files that contain only the data stored within the table.
E
Delta tables are stored in a single file that contains only the data stored within the table.
Explanation:
Explanation
Delta tables use a collection of files (Parquet files) to store data, along with a transaction log (Delta Log) that contains metadata, history, and other attributes. This architecture enables ACID transactions, time travel, and schema evolution.
Key points about Delta table storage:
- Data files: Stored as Parquet files in a collection
- Transaction log (Delta Log): Contains metadata, transaction history, schema information, and other attributes
- Separation of concerns: Data is stored in Parquet files, while metadata and transaction history are stored in the Delta Log
- ACID compliance: Enabled by the transaction log
- Time travel: Made possible by maintaining version history in the transaction log
Why other options are incorrect:
- A: Incorrect - Delta tables are not stored in a single file
- B: Incorrect - Data is stored in multiple Parquet files, not a single file
- D: Incorrect - The collection of files contains more than just data (includes transaction log)
- E: Incorrect - Delta tables are not stored in a single file and contain more than just data
Comments
Loading comments...