DP-600 · Question #27
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 r
The correct answer is A. Split OrderDateTime into separate date and time columns. D. Replace TotalSalesAmount with a measure.. To reduce memory usage and refresh time for an Import mode semantic model with a large table, splitting datetime columns and replacing calculated columns with measures are key optimizations.
Question
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.
Exhibit
Options
- ASplit OrderDateTime into separate date and time columns.
- BReplace TotalQuantity with a calculated column.
- CConvert Quantity into the Text data type.
- DReplace TotalSalesAmount with a measure.
How the community answered
(45 responses)- A80% (36)
- B13% (6)
- C7% (3)
Why each option
To reduce memory usage and refresh time for an Import mode semantic model with a large table, splitting datetime columns and replacing calculated columns with measures are key optimizations.
Splitting a `DateTime` column into separate `Date` and `Time` columns optimizes memory usage because the VertiPaq engine can apply more efficient compression to distinct date and time data types compared to a single combined datetime column.
Replacing `TotalQuantity` with a calculated column would increase memory usage, as calculated columns are materialized and stored for all 100 million rows, consuming valuable memory.
Replacing a materialized calculated column like `TotalSalesAmount` with a measure saves memory because measures are computed on-the-fly during query execution and do not consume storage space within the model for every row, unlike calculated columns.
Concept tested: Import mode model optimization (memory, refresh)
Source: https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-optimization-guidance
Topics
Community Discussion
No community discussion yet for this question.