Exam DP-700 topic 3 question 5 discussion

Actual exam question from Microsoft's DP-700

Question #: 5
Topic #: 3

You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table named Table1.
You analyze Table1 and discover that Table1 contains 2,000 Parquet files of 1 MB each.
You need to minimize how long it takes to query Table1.
What should you do?

A. Disable V-Order and run the OPTIMIZE command.
B. Disable V-Order and run the VACUUM command.
C. Run the OPTIMIZE and VACUUM commands.

Show Suggested Answer

Suggested Answer: C 🗳️

by GHill1982 at Jan. 1, 2025, 7:15 p.m.

Comments

Submit Cancel

GHill1982

Highly Voted 6 months ago

Selected Answer: C

OPTIMIZE: This will help compact the small Parquet files into larger files, improving the efficiency of queries. VACUUM: This will remove old versions of files that are no longer needed, freeing up storage and further optimizing performance.

upvoted 9 times

...

smanzana

Most Recent 2 weeks, 3 days ago

Selected Answer: C

C is correct

upvoted 1 times

...

DarioReymago

3 weeks, 6 days ago

Selected Answer: C

C is the correct

upvoted 1 times

...

prabhjot

4 months, 4 weeks ago

Selected Answer: C

Optimize command solves the "small file" problem and the "VACUUM" command erases the older versions of the parquet files thus optimizing on storage and better readability

upvoted 2 times

...

Tuki93

5 months ago

Selected Answer: C

Provided answer C is correct

upvoted 2 times

...