PL-300 · Question #436
PL-300 Question #436: Real Exam Question with Answer & Explanation
The correct answer is A: Summarize the detail data.. In Import mode, the entire dataset is loaded into memory, so reducing model size requires reducing data volume or storage footprint. Summarizing detail data (A) reduces the number of rows by replacing granular transaction rows with aggregated summaries, directly shrinking the dat
Question
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.
Options
- ASummarize the detail data.
- BUpgrade to Power BI premium.
- CImplement row-level security (RLS).
- DOptimize the column data types.
- EChange the active relationships between tables to inactive relationships.
Explanation
In Import mode, the entire dataset is loaded into memory, so reducing model size requires reducing data volume or storage footprint. Summarizing detail data (A) reduces the number of rows by replacing granular transaction rows with aggregated summaries, directly shrinking the dataset. Optimizing column data types (D) - for example, using integers instead of decimals, or replacing long text with shorter codes - reduces the bytes required per value and allows the VertiPaq engine to compress data more efficiently. Upgrading to Premium (B) increases capacity but does not reduce model size. Implementing RLS (C) restricts what users see but has no effect on stored data size. Changing active to inactive relationships (E) affects query behavior but has no impact on model size.
Community Discussion
No community discussion yet for this question.