DP-600 · Question #71
DP-600 Question #71: Real Exam Question with Answer & Explanation
The correct answer is D: Run the VACUUM command.. To remove files from a Delta table that are no longer referenced by the current version of the table, you should run the VACUUM command. https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-table-maintenance
Question
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?
Options
- AFrom OneLake file explorer, delete the files.
- BRun the OPTIMIZE command and specify the Z-order parameter.
- CRun the OPTIMIZE command and specify the V-order parameter.
- DRun the VACUUM command.
Explanation
To remove files from a Delta table that are no longer referenced by the current version of the table, you should run the VACUUM command. https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-table-maintenance
Topics
Community Discussion
No community discussion yet for this question.