Analyzing and Visualizing Data with Microsoft Excel — Question 3

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?

Answer options

• 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

Correct answer: A

Explanation

Using a measure for Total instead of storing it as a column significantly reduces memory consumption because measures are computed on the fly during analysis rather than being stored in memory. A calculated column would still occupy memory since it would be stored in the data model. Removing duplicates does not directly address the issue of memory usage related to the Total column, and moving the Total column to a lookup table could complicate the relationships and calculations needed for visualizations.