Free Preparation Discussions
MENU
Microsoft DP-600 Exam - Topic 1 Question 51 Discussion
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 Model! 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 memory usage and refresh time, splitting the OrderDateTime into separate date and time columns (A) can help optimize the model because date/time data types can be more memory-intensive than separate date and time columns. Moreover, replacing TotalSalesAmount with a measure (D) instead of a calculated column ensures that the calculation is performed at query time, which can reduce the size of the model as the value is not stored but calculated on the fly. Reference = The best practices for optimizing Power BI models are detailed in the Power BI documentation, which recommends using measures for calculations that don't need to be stored and adjusting data types to improve performance.
Deandrea
4 days agoDierdre
9 days agoCaitlin
14 days agoClay
19 days agoAllene
25 days agoEileen
30 days agoCarylon
1 month agoGeorgene
1 month agoPok
2 months agoMaricela
2 months agoGenevieve
2 months agoKina
2 months agoDenny
2 months agoKanisha
2 months agoEric
3 months agoRoxanne
3 months agoJacqueline
3 months agoAnnamae
4 months ago