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
Correct Answer: C
Delta tables are stored as a collection of files in cloud storage (like Azure Blob Storage, AWS S3, or Google Cloud Storage) that contain:
- Data files (Parquet format) containing the actual table data
- Transaction log files (JSON format) containing metadata, history, and transaction information
- Checkpoint files (Parquet format) for faster transaction log processing
Why other options are incorrect:
A: Incorrect - Delta tables are NOT stored in a single file. They use a collection of files.
B: Incorrect - While metadata is stored separately in transaction logs, the data is also stored in multiple Parquet files, not a single file.
D: Incorrect - Delta tables contain more than just data files; they include transaction logs and metadata.
E: Incorrect - Delta tables are not stored in a single file and contain more than just data.
Key Points:
- Delta Lake uses a multi-file architecture for scalability and performance
- Transaction logs enable ACID transactions and time travel capabilities
- The separation of data and metadata allows for efficient operations and versioning
- This architecture enables features like schema evolution, data versioning, and audit trails
Comments
Loading comments...