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.
To reduce the memory used by the model and minimize the refresh time, two actions are most effective. First, splitting the OrderDateTime into separate date and time columns can enable better data compression since data with higher redundancy can be compressed more effectively, reducing overall memory usage. Second, replacing TotalSalesAmount with a measure is beneficial because measures are not stored in memory and are calculated on demand, which reduces the memory footprint of the model.
A : Best practice D : measure better than column
Its AD
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.
A should compress the memory size D should reduce the memory usage but
It's A D
B&D are correct.
A and D
The correct answer is A and D
IMHO, A & D