Databricks Data Engineer Associate Question 102
Single answerYou are tasked with analyzing a table in Databricks, and you need to determine whether it is a Delta Lake table or not. Which of the following indicates that the table is NOT a Delta Lake table?
- A
The table's storage format is 'csv'.
- B
The table contains a '_delta_log' directory in its storage path.
- C
The table's metadata includes 'delta' as the format.
- D
The table supports ACID transactions.
Show answer and explanation
Correct answer: A
Explanation
Delta Lake tables have specific characteristics, such as the presence of a '_delta_log' directory, support for ACID transactions, and metadata indicating the 'delta' format. External sources like CSV, JSON, or Parquet files are not Delta Lake tables unless explicitly converted. Identifying the storage format as 'csv' confirms that the table is not a Delta Lake table.
- A. Correct.
Correct: A table stored in 'csv' format is not a Delta Lake table since Delta Lake uses its own format and metadata structure.
- B. Incorrect.
Incorrect: The presence of a '_delta_log' directory indicates that the table is a Delta Lake table because this directory is exclusive to Delta Lake.
- C. Incorrect.
Incorrect: If the table's metadata specifies 'delta' as the format, it confirms that the table is a Delta Lake table.
- D. Incorrect.
Incorrect: Delta Lake tables support ACID transactions, which is one of their key features and differentiators.