Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-700 Exam - Topic 1 Question 27 Discussion

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?
A) VACUUM
B) COMPUTE
C) OPTIMIZE
D) CLONE

Microsoft DP-700 Exam - Topic 1 Question 27 Discussion

Actual exam question for Microsoft's DP-700 exam
Question #: 27
Topic #: 1
[All DP-700 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

VACUUM is used to clean up storage by removing files no longer in use by a Delta table. It removes old and unreferenced files from Delta tables. For example, to remove files older than 7 days:

VACUUM delta.`/path_to_table` RETAIN 7 HOURS;


by Brandon at Apr 11, 2026, 08:39 PM

Limited Time Offer

25%

Off

Get Premium DP-700 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Flo
4 days ago
I think it's A) VACUUM.
upvoted 0 times
...
Fernanda
9 days ago
This question is tricky.
upvoted 0 times
...
Deja
15 days ago
OPTIMIZE is for performance, not file removal!
upvoted 0 times
...
Lawrence
20 days ago
I thought COMPUTE might be the answer, but VACUUM makes sense.
upvoted 0 times
...
Dion
25 days ago
Wait, does VACUUM really remove files older than seven days?
upvoted 0 times
...
Lynelle
2 months ago
Totally agree, VACUUM cleans up old files.
upvoted 0 times
...
Miss
3 months ago
A) VACUUM is the right choice for that!
upvoted 0 times
...
Emile
3 months ago
I feel like CLONE is definitely not the right answer here, but I can't recall what COMPUTE does in this context.
upvoted 0 times
...
Bettye
3 months ago
I’m a bit confused. I thought OPTIMIZE was for improving performance, not for deleting old files.
upvoted 0 times
...
Dalene
3 months ago
I remember practicing a question about cleaning up old files, and VACUUM was mentioned there too. It seems like the right choice.
upvoted 0 times
...
Carli
4 months ago
I think the command we need is VACUUM, but I'm not entirely sure if it specifically targets files older than seven days.
upvoted 0 times
...

Save Cancel