Exam 70-779 topic 1 question 40 discussion

Actual exam question from Microsoft's 70-779

Question #: 40
Topic #: 1

You have a table in a Power Pivot model that is loaded from a Microsoft SQL Server database.
The source table has four columns named ID, Price, Quantity, and Total. Total is derived by multiplying Price and Quantity. ID is a unique row identifier.
You need to minimize the amount of memory used to load the model. The solution must ensure that you can create visualizations based on Price, Quantity, and
Total.
What should you do?

A. Replace the Total column by using a measure
B. Replace the Total column by using a calculated column
C. From Query Editor, remove duplicate rows from the table
D. Move the Total column to a lookup table

Show Suggested Answer

Suggested Answer: A 🗳️
References:
https://support.office.com/en-us/article/create-a-memory-efficient-data-model-using-excel-and-the-power-pivot-add-in-951c73a9-21c4-46ab-9f5e-
14a2833b6a70#__toc373850959

by exam_taker5 at July 17, 2019, 9:02 p.m.

Comments

Submit Cancel

Luddite2

Highly Voted 5 years, 11 months ago

‘A’ seems to be correct. Measure can replace column to minimize memory consumption. https://support.office.com/en-us/article/create-a-memory-efficient-data-model-using-excel-and-the-power-pivot-add-in-951c73a9-21c4-46ab-9f5e-14a2833b6a70

upvoted 28 times

r8d1

5 years ago

from the link: One memory-saving technique is to replace regular or calculated columns with calculated measures. The classic example is Unit Price, Quantity, and Total.

upvoted 3 times

...

Hump

Highly Voted 5 years, 8 months ago

A is correct, "SUMX" can be used. B doem't reduce the size

upvoted 8 times

...

CDL

Most Recent 4 years, 10 months ago

A is right, Tested. One memory-saving technique is to replace regular or “calculated columns” with “calculated measures”. And “calculated measures” = SumX, avgX, countX…etc (iterator functions) Calculated measures means {“calculated columns” + “aggregate”}, the key point here is that at last it will release “calculated columns” temporary memory usage. “Iterator functions are looping through all rows in the input table and storing the expression result in a temporary memory storage. At the end they apply the aggregation on the temporary storage results, release the memory usage, and visualize the calculation result.”

upvoted 3 times

...

Waltmas

5 years ago

A for memory efficiency

upvoted 1 times

...

SN22

5 years, 6 months ago

A is correct

upvoted 4 times

...

mikeadex

5 years, 8 months ago

A is the correct answer...measure reduces memory usage compared to calculated columns that takes more.

upvoted 5 times

...

mohroshdy

5 years, 8 months ago

"A. Replace the Total column by using a measure" is the correct answer to optimize the workbook you can replace the calculated columns by measures and you can use this measure in any visualization instead, in our case it's possible to do so.

upvoted 5 times

...