DP-700 · Question #10
DP-700 Question #10: Real Exam Question with Answer & Explanation
Sign in or unlock DP-700 to reveal the answer and full explanation for question #10. The question stem and answer options stay visible for context.
Question
You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modeled by using MDS metadata. 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?
Options
- AChange the MD5 hash to SHA256.
- BIncrease the capacity.
- CEnable v-Order.
- DModify the surrogate keys to use a different data type.
- ECreate views.
Unlock DP-700 to see the answer
You've previewed enough free DP-700 questions. Unlock DP-700 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.