Exam Certified Data Engineer Associate All QuestionsBrowse all questions from this exam
Go to Exam
Question 5

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

    Correct Answer: C

    Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes. This organization allows Delta tables to maintain a structured manner of storing data using formats like Parquet files for the actual data, while also keeping track of metadata and transaction logs in separate directories. This structure supports features such as versioning, transaction management, and metadata tracking, which are essential for Delta tables to provide ACID transactions and other advanced functionalities.

Discussion
benni_aleOption: C

GPT4: Delta tables in Databricks use: Parquet format files for data storage. A _delta_log folder for JSON log files that track transactions. Scheme enforcement in metadata to ensure consistency. Checkpoint files to speed up the rebuilding of the table state.

vctrhugoOption: C

C. Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes. Delta tables store data in a structured manner using Parquet files, and they also maintain metadata and transaction logs in separate directories. This organization allows for versioning, transactional capabilities, and metadata tracking in Delta Lake. Thank you for pointing out the error, and I appreciate your understanding.

prasiosoOption: C

First selected D as I assumed the data to be stored in the Delta lake and the transaction log to be stored separately. However, documentation states when a user creates a Delta Lake table, that table’s transaction log is automatically created in the _delta_log subdirectory. The deltalog contains multiple files hence a collection of files. Answer C.

Data_4everOption: C

C is the right option

Sriramiyer92

Reading Material: 5 reasons to choose Delta format (on Databricks) https://medium.com/datalex/5-reasons-to-use-delta-lake-format-on-databricks-d9e76cf3e77d

andie123Option: C

C is the right answer

AtnafuOption: C

C Delta tables in Databricks Delta Lake are stored in a collection of files organized in a directory structure. This directory structure includes data files, transaction log files, and metadata files. These files are stored in a specified location, typically in a distributed file system such as Hadoop Distributed File System (HDFS) or Amazon S3.

XiltroXOption: C

C is correct answer https://docs.delta.io/latest/delta-faq.html#:~:text=Delta%20Lake%20uses%20versioned%20Parquet,directory%20to%20provide%20ACID%20transactions.

mascarenhaslucasOption: C

The answer is C!

ItmmaOption: C

C is correct

SerGreyOption: C

C is correct

VijayKulaOption: C

Answer is C

KalavathiPOption: C

Correct ans C

kniveszOption: C

C , respuesta correcta