Answer-first summary for fast verification
Answer: Split OrderDateTime into separate date and time columns., Replace TotalSalesAmount with a measure.
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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.
No comments yet.