Databricks Certified Data Engineer Associate — Question 3

Which of the following describes the storage organization of a Delta table?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because Delta tables are indeed structured as a collection of files that hold data, history, metadata, and other attributes, which allows for efficient data management and versioning. Options A, B, D, and E incorrectly describe Delta tables as being contained within a single file or lacking necessary components like history and metadata.