Answer-first summary for fast verification
Answer: Run the VACUUM command.
To remove files from a Delta table that are no longer referenced by the current version of the table while ensuring that the transaction log remains consistent and the ACID properties of the table are maintained, you should use the VACUUM command. The VACUUM command deletes files that are not currently referenced by a Delta table for a specified retention period, which by default is 7 days but can be adjusted as needed, such as 30 days in this case.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are managing a Fabric tenant which includes a lakehouse called Lakehouse1. Within Lakehouse1, there is a Delta table comprising one million Parquet files. Your task is to identify and eliminate files that have not been referenced by the Delta table in the last 30 days. It is crucial that this process preserves the consistency of the transaction log and maintains the ACID (Atomicity, Consistency, Isolation, Durability) properties of the table. What steps should you take to achieve this?
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.