Exam DP-600 topic 1 question 115 discussion

Actual exam question from Microsoft's DP-600

Question #: 115
Topic #: 1

HOTSPOT
-

You have a Fabric tenant that contains a semantic model named model1. The two largest columns in model1 are shown in the following table.

You need to optimize model1. The solution must meet the following requirements:

• Reduce the model size.
• Increase refresh performance when using Import mode.
• Ensure that the datetime value for each sales transaction is available in the model.

What should you do on each column? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Martin_Nbg at Oct. 6, 2024, 9:45 a.m.

Comments

Submit Cancel

Martin_Nbg

Highly Voted 7 months, 3 weeks ago

Correct: Remove + Split

upvoted 12 times

...

nappi1

Highly Voted 6 months, 1 week ago

TransactionKey --> Remove the column. There is no need to keep 160 GB for a surrogate key, it can be removed and SaleDateTime can be moved into the SalesTransaction table that will for sure "Increase refresh performance when using Import mode." and "Reduce the model size." since there is no need for an heavy join like this one. SaleDateTime --> Split the column. Splitting the column would lead for sure to "Ensure that the datetime value for each sales transaction is available in the model." and i think it would lead to a better segmentation of the data meaning less cardinality that would lead to "Increase refresh performance when using Import mode." and "Reduce the model size."

upvoted 8 times

...