Exam DP-600 topic 1 question 32 discussion

Actual exam question from Microsoft's DP-600

Question #: 32
Topic #: 1

You have a Fabric tenant that contains a semantic model named Model1. Model1 uses Import mode. Model1 contains a table named Orders. Orders has 100 million rows and the following fields.

You need to reduce the memory used by Model1 and the time it takes to refresh the model.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.

A. Split OrderDateTime into separate date and time columns.
B. Replace TotalQuantity with a calculated column.
C. Convert Quantity into the Text data type.
D. Replace TotalSalesAmount with a measure.

Show Suggested Answer

Suggested Answer: AD 🗳️

by fabric1 at Feb. 13, 2024, 9:48 a.m.

Comments

Submit Cancel

Momoanwar

Highly Voted 1 year, 3 months ago

A : Best practice D : measure better than column

upvoted 28 times

...

fabric1

Highly Voted 1 year, 3 months ago

I was under the impression that A should be correct due to the fact that separate date and time column achieve higher columnar redundancy and allow better data compression. Whereas solution B, an additional calculated column, would inflate the memory usage. Measure are not stored in memory and would therefore be favorable concerning the stated objective of reducing memory used and minimizing refresh times.

upvoted 9 times

...