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 1 question 5 discussion

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

You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modelled by using MD5 hash surrogate keys.
DW1 contains a single fact table that has grown from 200 million rows to 500 million rows during the past year.
You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year values.
Users report that the performance of some of the reports has degraded over time and some visuals show errors.
You need to resolve the performance issues. The solution must meet the following requirements:
Provide the best query performance.
Minimize operational costs.
Which should you do?

  • A. Change the MD5 hash to SHA256.
  • B. Increase the capacity.
  • C. Enable V-Order.
  • D. Modify the surrogate keys to use a different data type.
  • E. Create views.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by IshtarSQL at Dec. 6, 2024, 8:45 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
mixonfreddy
1 week, 2 days ago
Selected Answer: D
You have to modify the surrogate keys
upvoted 2 times
...
manolet
2 weeks ago
Selected Answer: C
Changing surrogate keys is not a straightforward solution. The key is that you need to make the decision based on minimizing operational cost.
upvoted 1 times
...
QAZdbarhate12345678
3 weeks ago
Selected Answer: D
The best solution to resolve the performance issues while meeting the requirements of best query performance and minimizing operational costs is: D. Modify the surrogate keys to use a different data type.
upvoted 2 times
...
Tuki93
4 weeks ago
Selected Answer: C
Enable V-Order: This should be your first step as it directly targets performance improvements with minimal cost. Consider the following before deciding to disable V-Order: Microsoft Fabric Direct Lake mode depends on V-Order. https://learn.microsoft.com/en-us/fabric/data-warehouse/v-order#performance-considerations
upvoted 4 times
GHill1982
2 weeks, 1 day ago
Would V-Order not already be enabled by default?
upvoted 2 times
...
...
IshtarSQL
1 month ago
Selected Answer: D
While MD5 hashes are deterministic and ensure uniqueness, they can be less efficient for join operations compared to integer-based keys. This inefficiency arises because joining on lengthy string keys demands more computational resources than joining on shorter, integer-based keys. Recommendation: Modify the surrogate keys to use a different data type, specifically integers.
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