Microsoft DP-700 Exam - Topic 1 Question 27 Discussion

Actual exam question for Microsoft's DP-700 exam

Question #: 27
Topic #: 1

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?

AVACUUM

BCOMPUTE

COPTIMIZE

DCLONE

Show Suggested 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:

Submit Cancel

Lynelle

23 days ago

Totally agree, VACUUM cleans up old files.

upvoted 0 times

...

Miss

28 days ago

A) VACUUM is the right choice for that!

upvoted 0 times

...

Emile

1 month 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

2 months ago

I’m a bit confused. I thought OPTIMIZE was for improving performance, not for deleting old files.

upvoted 0 times

...

Dalene

2 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

2 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

...