Exam DP-700 topic 1 question 59 discussion

Actual exam question from Microsoft's DP-700

Question #: 59
Topic #: 1

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. Create views.
B. Modify the surrogate keys to use a different data type.
C. Change the MD5 hash to SHA256.
D. Increase the capacity.
E. Disable V-Order on the warehouse.

Show Suggested Answer

Suggested Answer: B 🗳️

by gretito_g at June 9, 2025, 2:07 p.m.

Comments

Submit Cancel

Acrious

3 weeks, 6 days ago

Selected Answer: B

While adding capacity would possibly do this, minimizing costs pushes us to select B, as changing a string type to an INT type would improve performance. Will it be enough... no way to measure but it would be the first step I would take

upvoted 1 times

...

ca_acc

4 weeks, 1 day ago

Selected Answer: D

I dunno if this answer is correct within the exam. But it only can be: D. 300 Mio Row Lmitations in a warehouse at F32. Otherwise, we could split into to Views, to be within the Row Limits of 200 and 300 rows, for two different Years.

upvoted 2 times

...

VenkataPhaniPavanKumar

1 month ago

Selected Answer: D

We should increase the capacity. Check this explanation https://www.youtube.com/watch?v=LX3EJX-LIFY&list=PLO3dD0hSou5e4ErRvooMc-ifeotjAt06g&index=4

upvoted 1 times

...

PBridge

1 month, 3 weeks ago

Selected Answer: B

Changing surrogate keys from MD5 (string) to integers improves query speed, storage efficiency, and reduces costs.

upvoted 1 times

bcbc59b

2 weeks, 1 day ago

Did you consider how much ETL cost will increase? Using and int key requires a join of fact and dimension tables to assign the keys while a hash does not.

upvoted 1 times

...

kaushikcbs

1 month, 3 weeks ago

Selected Answer: B

Modify the surrogate keys to use a different data type Why? - MD5 hash surrogate keys are 128-bit values, which can be inefficient for large datasets. - Switching to a more efficient data type (such as BIGINT or INT) reduces storage and processing overhead, improving query performance. - Smaller data types are faster to process, leading to better indexing and query execution. Answer validated with ChatGPT

upvoted 2 times

...

gretito_g

1 month, 3 weeks ago

Selected Answer: B

Modify the surrogate keys to use a different data type.

upvoted 2 times

...