A data engineer has created a transactions Delta table on Databricks that should be used...

Delta Lake introduced Delta Universal Format (Delta UniForm), which allows seamless interoperability between Delta Lake and Apache Iceberg. This means a Delta table can be converted into an Iceberg table while maintaining Delta capabilities.

Explanation of Each Option:

(A) Require the analytics team to use a tool that supports Delta table

Incorrect: While Delta Lake is widely used, requiring the team to change tools is not a flexible or scalable solution.

(B) Enable uniform on the transactions table to 'iceberg' so that the table can be read as an Iceberg table

Incorrect:

The uniform feature must be enabled after conversion.

You cannot directly enable uniform without first converting the table.

(C) Create an Iceberg copy of the transactions Delta table which can be used by the analytics team

Incorrect:

Creating a separate Iceberg copy would duplicate storage and increase maintenance complexity.

This is not necessary when Delta UniForm allows direct compatibility with Iceberg.

(D) Convert the transactions Delta table to Iceberg and enable uniform so that the table can be read as a Delta table

Correct:

The best approach is to convert the existing Delta table to Iceberg using the Databricks Delta to Iceberg migration tools.

After conversion, enabling uniform ensures the table remains accessible in both Delta and Iceberg formats.

Conclusion:

The best practice for interoperability between Delta and Iceberg is to convert the Delta table to Iceberg and enable uniform, ensuring cross-compatibility without data duplication.

Thus, Option (D) is the correct answer.