DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

Question

You have a Fabric workspace containing a lakehouse and a notebook called Notebook1. Notebook1 reads data from a table named Table1 into a DataFrame and applies transformation logic. The DataFrame data is then written to a new Delta table named Table2 by using a merge operation.

You need to consolidate the underlying Parquet files in Table1.

Which command should you run?

Explanation

For a Delta table, OPTIMIZE performs bin compaction, consolidating many small Parquet files into fewer, larger files to reduce file-management overhead and improve read efficiency. VACUUM instead removes unreferenced files that are older than the retention window.

Learn more

Delta table maintenance in Microsoft Fabric

DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

AstroTutor

Notes

Readiness

QuestionQ50

Community Discussion