Delta Lake introducedDelta Universal Format (Delta UniForm), which allowsseamless interoperability between Delta Lake and Apache Iceberg. This means a Delta table can beconverted 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 toolsis 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 featuremust be enabled after conversion.

You cannotdirectly enable uniformwithout firstconverting 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 wouldduplicate storage and increase maintenance complexity.

This is not necessary whenDelta 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 toconvert the existing Delta table to Icebergusing the DatabricksDelta to Iceberg migration tools.

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

Conclusion:

The best practice forinteroperability between Delta and Icebergis toconvert the Delta table to Iceberg and enable uniform, ensuringcross-compatibilitywithout data duplication.Thus,Option (D) is the correct answer.

References:

Delta UniForm for Apache Iceberg - Databricks Documentation

Convert Delta to Iceberg - Databricks