Optimize performance
4 practice questions under this official exam objective (DP-700) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
A 500-million-row fact table exceeds the F32 Direct Lake guardrail, so increase the capacity to F64
DW1's fact table grew to 500 million rows, above the F32 Direct Lake guardrail of 300 million rows per table, so Direct Lake falls back to DirectQuery
OPTIMIZE consolidates the small Parquet files of a Delta table
Running OPTIMIZE on Table1 compacts its many small Parquet files into larger ones, solving the small-file problem; VACUUM only removes files no longer
VACUUM removes lakehouse files older than seven days that are no longer in use
The VACUUM command on the lakehouse table removes files no longer referenced by the Delta log and older than the retention threshold, which defaults t
OPTIMIZE plus VACUUM minimizes query time on a table of 2,000 one-MB files
Table1's 2,000 Parquet files of 1 MB each create a small-file problem: OPTIMIZE consolidates them into fewer large files for faster scans, and VACUUM