Databricks Data Engineer Associate Question 103
Select 3You are working on a Databricks project where multiple tables are stored in different formats. You need to determine which tables are not Delta Lake tables to avoid using Delta-specific features on them. Given the following scenario, which of the following statements correctly help identify a non-Delta table?
- A
The table's storage format is listed as 'parquet' when using the DESCRIBE DETAIL command.
- B
The table's metadata includes a '_delta_log' directory in its storage location.
- C
The table was created using the SQL statement 'CREATE TABLE ... USING DELTA'.
- D
The table's storage format is listed as 'csv' when using the DESCRIBE DETAIL command.
- E
The table does not support ACID transactions or time travel operations.
Show answer and explanation
Correct answers: A, D, E
Explanation
Delta Lake tables use the 'delta' format and have unique features like ACID compliance and time travel. Non-Delta tables will lack these features and may be stored in formats like 'parquet' or 'csv'. By examining the table format and associated features, you can distinguish Delta tables from non-Delta tables.
- A. Correct.
Correct. A table stored in 'parquet' format is not a Delta table. Delta tables use the 'delta' format.
- B. Incorrect.
Incorrect. The presence of a '_delta_log' directory indicates that the table is a Delta table, as this directory is used to track changes.
- C. Incorrect.
Incorrect. If the table was created using 'USING DELTA', it is explicitly a Delta table.
- D. Correct.
Correct. A table stored in 'csv' format is not a Delta table, as Delta tables do not use the 'csv' format.
- E. Correct.
Correct. Delta tables support ACID transactions and time travel, so a table lacking these features is not a Delta table.