BenchMark Quizzes by MDFT Pro

Choose the correct command to remove unused files

You work for MDFT Pro, a well-known training agency that uses Microsoft Fabric for data analytics. Your Fabric tenant contains a lakehouse named CourseHouse. The lakehouse 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?

Choose the correct answer from the options below.

Explanations for each answer:

From OneLake file explorer, delete the files is incorrect. Manually deleting files through the file explorer bypasses the Delta Lake transaction log, which can lead to data inconsistency and violates ACID properties
Run the OPTIMIZE command and specify the Z-order parameter is incorrect. The OPTIMIZE command with Z-order is used to improve query performance by co-locating related data, not for removing unused files
Run the OPTIMIZE command and specify the V-order parameter is incorrect. The OPTIMIZE command with V-order is used for data organization and performance optimization, not for removing unused files
Run the VACUUM command is correct.

Learn more about the VACUUM command:

VACUUM Command

Exam Preparation Quiz

Choose the correct command to remove unused files