MENU
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?
Suggested Answer: A
Get Premium DP-700 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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;
22 comments · newest first
CA
Catarina
1 month ago
VACUUM seems like the best choice.
LE
Lenita
1 month ago
OPTIMIZE is for performance, not file removal.
DY
Dylan
2 months ago
I agree, but what about C) OPTIMIZE?
DO
Donette
2 months ago
It removes old files, right?
TA
Talia
2 months ago
Why VACUUM?
DO
Donette
2 months ago
I think it's A) VACUUM.
CA
Catarina
2 months ago
This question is tricky.
HE
Heidy
3 months ago
I was leaning towards C) OPTIMIZE, but VACUUM seems better.
GI
Gilma
3 months ago
I agree, A) makes sense.
FL
Flo
3 months ago
It removes old files, right?
DA
Darell
3 months ago
Why VACUUM?
FL
Flo
3 months ago
I think it's A) VACUUM.
FE
Fernanda
3 months ago
This question is tricky.
DE
Deja
4 months ago
OPTIMIZE is for performance, not file removal!
LA
Lawrence
4 months ago
I thought COMPUTE might be the answer, but VACUUM makes sense.
DI
Dion
4 months ago
Wait, does VACUUM really remove files older than seven days?
LY
Lynelle
5 months ago
Totally agree, VACUUM cleans up old files.
MI
Miss
6 months ago
A) VACUUM is the right choice for that!
EM
Emile
6 months ago
I feel like CLONE is definitely not the right answer here, but I can't recall what COMPUTE does in this context.
BE
Bettye
6 months ago
I’m a bit confused. I thought OPTIMIZE was for improving performance, not for deleting old files.
DA
Dalene
6 months ago
I remember practicing a question about cleaning up old files, and VACUUM was mentioned there too. It seems like the right choice.
CA
Carli
7 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.