Microsoft DP-700 Exam - Topic 1 Question 29 Discussion

Actual exam question for Microsoft's DP-700 exam

Question #: 29
Topic #: 1

Exhibit.

You have a Fabric workspace that contains a write-intensive warehouse named DW1. DW1 stores staging tables that are used to load a dimensional model. The tables are often read once, dropped, and then recreated to process new data.

You need to minimize the load time of DW1.

What should you do?

ADisable V-Order.

BDrop statistics.

CEnable V-O-der.

DCreate statistics.

Show Suggested Answer

Suggested Answer: A

by Una at May 17, 2026, 07:06 PM

Limited Time Offer

25%

Off

Get Premium DP-700 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lenna

4 days ago

Disagree, I’d go with enabling V-Order instead.

upvoted 0 times

...

Emilio

10 days ago

I think creating statistics is key for performance.

upvoted 0 times

...

Ivette

15 days ago

I’m a bit confused about V-Order; I thought it was supposed to optimize loading, but now I’m not so sure.

upvoted 0 times

...

Bernardo

20 days ago

I practiced a similar question where creating statistics improved performance, so I’m leaning towards that option.

upvoted 0 times

...

Launa

25 days ago

Dropping statistics sounds familiar, but I feel like creating statistics might actually help with load times.

upvoted 0 times

...

Martin

2 months ago

I think I remember something about V-Order, but I'm not sure if enabling or disabling it is the right choice here.

upvoted 0 times

...