Q: 9
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.
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.Options
Discussion
Its B and D, both directly cut stored data size in memory. Pretty sure that's what MS wants for import models here.
Option C
B and D, combining calculated columns and measures will lower memory use here.
Be respectful. No spam.