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
Dylan
4 days ago
I agree, but what about C) OPTIMIZE?
upvoted 0 times
...
Donette
9 days ago
It removes old files, right?
upvoted 0 times
...
Talia
14 days ago
Why VACUUM?
upvoted 0 times
...
Donette
20 days ago
I think it's A) VACUUM.
upvoted 0 times
...
Catarina
25 days ago
This question is tricky.
upvoted 0 times
...
Heidy
30 days ago
I was leaning towards C) OPTIMIZE, but VACUUM seems better.
upvoted 0 times
...
Gilma
1 month ago
I agree, A) makes sense.
upvoted 0 times
...
Flo
1 month ago
It removes old files, right?
upvoted 0 times
...
Darell
2 months ago
Why VACUUM?
upvoted 0 times
...
Flo
2 months ago
I think it's A) VACUUM.
upvoted 0 times
...
Fernanda
2 months ago
This question is tricky.
upvoted 0 times
...
Deja
2 months ago
OPTIMIZE is for performance, not file removal!
upvoted 0 times
...
Lawrence
2 months ago
I thought COMPUTE might be the answer, but VACUUM makes sense.
upvoted 0 times
...
Dion
2 months ago
Wait, does VACUUM really remove files older than seven days?
upvoted 0 times
...
Lynelle
4 months ago
Totally agree, VACUUM cleans up old files.
upvoted 0 times
...
Miss
4 months ago
A) VACUUM is the right choice for that!
upvoted 0 times
...
Emile
5 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
5 months ago
I’m a bit confused. I thought OPTIMIZE was for improving performance, not for deleting old files.
upvoted 0 times
...
Dalene
5 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
5 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