ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam
Go to Exam

Exam DP-700 topic 3 question 5 discussion

Actual exam question from Microsoft's DP-700
Question #: 5
Topic #: 3
[All DP-700 Questions]

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 Hide Answer
Suggested Answer: C 🗳️
by GHill1982 at Jan. 1, 2025, 7:15 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
GHill1982
Highly Voted 4 months, 2 weeks 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 8 times
...
prabhjot
Most Recent 3 months, 1 week 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
3 months, 2 weeks ago
Selected Answer: C
Provided answer C is correct
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago