Exam DP-700 topic 3 question 14 discussion

Actual exam question from Microsoft's DP-700

Question #: 14
Topic #: 3

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?

A. Enable V-Order.
B. Create statistics.
C. Drop statistics.
D. Disable V-Order.

Show Suggested Answer

Suggested Answer: D 🗳️

by tarmapas at April 8, 2025, 2:37 p.m.

Comments

Submit Cancel

a85becd

Highly Voted 2 months, 1 week ago

Selected Answer: D

Option A is wrong, V-Order is enabled by default, there wouldn’t be a need to enable it again, even if not enabled, In staging scenarios like this—where tables are short-lived, often read once, and then dropped—read performance is not critical. The focus is instead on minimizing. V-Order introduces an average of 15% overhead on write times, which can negatively impact scenarios where load time is the top priority. Option D is correct: you can avoid the write-time overhead associated with V-Order optimization, making it the most suitable choice for your requirements.

upvoted 5 times

2 months, 3 weeks ago

Selected Answer: D

D is the correct answer

upvoted 4 times

Henry_01

2 months, 2 weeks ago

why is that ?

upvoted 1 times

ihmot

2 months, 2 weeks ago

V-Order is a write time optimization, has a 15% impact on average write times, but results in an average of 10% faster read times, with some scenarios up to 50%. https://learn.microsoft.com/en-us/fabric/data-engineering/delta-optimization-and-v-order?tabs=sparksql

upvoted 1 times

...