Exam DP-600 topic 1 question 77 discussion

Actual exam question from Microsoft's DP-600

Question #: 77
Topic #: 1

You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table that has one million Parquet files.

You need to remove files that were NOT referenced by the table during the past 30 days. The solution must ensure that the transaction log remains consistent, and the ACID properties of the table are maintained.

What should you do?

A. From OneLake file explorer, delete the files.
B. Run the OPTIMIZE command and specify the Z-order parameter.
C. Run the OPTIMIZE command and specify the V-order parameter.
D. Run the VACUUM command.

Show Suggested Answer

Suggested Answer: D 🗳️

by prabhjot at April 5, 2024, 7:28 p.m.

Comments

Submit Cancel

Nefirs

Highly Voted 6 months, 2 weeks ago

Selected Answer: D

D: https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-table-maintenance

upvoted 10 times

...

vernillen

Most Recent 4 months, 4 weeks ago

Selected Answer: D

Just think of the aspect of a real VACUUM: Cleanup of dust just lying around

upvoted 3 times

...

stilferx

5 months, 3 weeks ago

Selected Answer: D

IMHO, D) Vacuum is good

upvoted 2 times

...

prabhjot

7 months ago

Yes D - To remove files from a Delta table that are no longer referenced by the current version of the table, you should run the VACUUM command.

upvoted 4 times

...

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 77 discussion

Comments

Nefirs

vernillen

stilferx

prabhjot

SY0-701