Implementing Analytics Solutions Using Microsoft Fabric — Question 71

You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table that has one million Parquet files.

You need to remove files that were NOT referenced by the table during the past 30 days. The solution must ensure that the transaction log remains consistent, and the ACID properties of the table are maintained.

What should you do?

Answer options

• A. From OneLake file explorer, delete the files.
• B. Run the OPTIMIZE command and specify the Z-order parameter.
• C. Run the OPTIMIZE command and specify the V-order parameter.
• D. Run the VACUUM command.

Correct answer: D

Explanation

The correct answer is D, as the VACUUM command is specifically designed to remove files that are no longer referenced by the Delta table while ensuring the integrity of the transaction log and maintaining ACID properties. The other options do not achieve the requirement of safely deleting unreferenced files without compromising table consistency.