Exam DP-700 topic 3 question 14 discussion

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.

Disable V-Order - This avoids the write-time overhead of applying V-Order optimization Perfect for staging scenarios where: Tables are short-lived Read performance is not the priority Load time is more important

Why wouldn't A --> Enable V-Order be the correct answer?

D is the correct answer