Microsoft Power BI Data Analyst — Question 42

You have a Power BI semantic model named Model1 that runs in Import storage mode.

You need to reduce the size of Model1.

Which two actions should you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Answer options

• A. Summarize the detail data.
• B. Upgrade to Power BI premium.
• C. Implement row-level security (RLS).
• D. Optimize the column data types.
• E. Change the active relationships between tables to inactive relationships.

Correct answer: A, D

Explanation

Summarizing the detail data (A) reduces the overall data volume, while optimizing column data types (D) minimizes storage space by ensuring efficient data representation. The other options do not directly influence the size of the model; for example, upgrading to Power BI premium (B) increases capacity rather than reducing size, and implementing RLS (C) does not affect the model size.