Q: 9
You have a Fabric workspace that contains an eventstream named EventStream1. EventStream1 outputs events to a table in a lakehouse. You need to remove files that are older than seven days and are no longer in use. Which command should you run?
Options
Discussion
Option A is right, VACUUM is the command that cleans up files older than the retention period in Delta tables. OPTIMIZE helps with file organization but doesn’t delete unused data. I’m pretty sure on this, unless there’s some custom retention policy hiding in the question.
C
Anyone try this in a lab? Official docs or hands-on practice usually make the VACUUM vs OPTIMIZE difference really clear.
A
Option A but this only works if retention is set properly, otherwise the files might not be fully cleared.
A tbh, seen this in the official docs and some practice labs too.
C , since OPTIMIZE seems like the one to manage old files and improve storage. I think VACUUM is for more advanced cleanup, but C feels less risky in practice. Maybe I'm missing a trap here though.
Maybe C? OPTIMIZE also cleans up delta tables, and I think it's about improving file structure and performance. Not 100 percent though.
Its A, had something like this in a mock and VACUUM was the right pick.
A that's the VACUUM command's job. It removes old unused files from Delta tables after the retention period. Pretty sure this fits.
Be respectful. No spam.