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 14 discussion

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

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 Hide Answer
Suggested Answer: D 🗳️
by tarmapas at April 8, 2025, 2:37 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
jetplanes
1 day, 10 hours ago
Selected Answer: A
Why wouldn't A --> Enable V-Order be the correct answer?
upvoted 1 times
...
tarmapas
1 week, 3 days ago
Selected Answer: D
D is the correct answer
upvoted 3 times
Henry_01
1 day, 22 hours ago
why is that ?
upvoted 1 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