
Explanation:
Splitting OrderDateTime into separate date and time columns (A) achieves higher columnar redundancy and allows better data compression, reducing memory usage. Replacing TotalSalesAmount with a measure (D) is better than storing it as a column since measures are calculated on the fly and do not consume memory, thus optimizing memory usage and improving refresh times.
Ultimate access to all questions.
No comments yet.
As an administrator of a Fabric tenant, you manage a semantic model named Model1, which is configured to operate in Import mode. The model includes a table named Orders that contains 100 million rows, with the following fields:
To optimize Model1's performance in terms of reducing memory usage and minimizing refresh times, which two actions should you take? Each action contributes to 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.