VACUUM removes lakehouse files older than seven days that are no longer in use
Short answer
A VACUUM deletes files no longer referenced by the Delta log after the default seven-day retention, matching the cleanup requirement.
Question
Key Takeaways
VACUUM's default retention threshold is seven days; it deletes files older than that which are no longer referenced by the Delta table log.
The VACUUM command on the lakehouse table removes files no longer referenced by the Delta log and older than the retention threshold, which defaults to seven days - exactly the cleanup the eventstream landing table needs.
Common mistake: Using OPTIMIZE, which only consolidates small files; removing stale unreferenced files is VACUUM's job, while COMPUTE and CLONE serve entirely different purposes.
Expert Analysis
Why the Answer Is Correct
Files written by the eventstream land as Delta table files, and older versions become unreferenced as new data arrives. The VACUUM command removes files no longer referenced by the Delta log and older than the retention threshold, whose default is seven days - precisely the requirement to remove files older than seven days that are no longer in use.
Why the Other Options Are Wrong
Option C (OPTIMIZE) consolidates small files into larger ones but never deletes stale files. Option B (COMPUTE) is not a Delta maintenance command for cleanup. Option D (CLONE) creates a copy of a table rather than removing unused files.
Community Comment Notes
The community is unanimous (A 100). GHill1982 (4 likes) notes the default retention period for the VACUUM command is 7 days, and 38578c4 links the lakehouse table maintenance documentation.
Official Reference
https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-table-maintenance
This link opens the official vendor documentation in a new tab.
Community Votes
100% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 3 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 3
-
GHill1982 👍 4 Answered AThe default retention period for the VACUUM command is 7 days, therefore it will remove files older than 7 days.
-
Tuki93 👍 4 Answered AVACUUM is the corrected answer
-
38578c4 👍 2 Answered Ahttps://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-table-maintenance
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.