PL-300 Question #337: Real Exam Question with Answer & Explanation

Question

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend?

Options

• AReplace the default visuals with AppSource visuals.
• BRemove unused columns from tables in the data model.
• CChange the imported dataset to DirectQuery.
• DIncrease the number of times that the dataset is refreshed.

Explanation

To improve report loading and interaction performance with an imported dataset, remove unused columns to reduce the dataset's memory footprint and file size.

Common mistakes.

• A. Replacing default visuals with AppSource visuals can sometimes worsen performance if the AppSource visuals are less optimized, rather than improving it.
• C. Changing to DirectQuery generally decreases interactive performance compared to Import mode, as every interaction requires querying the source database live.
• D. Increasing the dataset refresh frequency impacts data freshness, not the speed at which the report loads or visuals interact once the data is already loaded.

Concept tested. Power BI data model optimization for performance

Reference. https://learn.microsoft.com/en-us/power-bi/guidance/power-bi-optimization-guidance-model-size-reduction

No community discussion yet for this question.