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

Question

You have a Microsoft Power Bl 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 custom 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

• ASplit the visuals onto multiple pages.
• BImplement row-level security (RLS).
• CReplace the default visuals with custom visuals.
• DIncrease the number of times that the dataset is refreshed.

Explanation

To improve report performance when users experience slow visual loading on a single page with many visuals, especially custom ones, splitting the visuals across multiple pages is recommended.

Common mistakes.

• B. Implementing row-level security (RLS) restricts data visibility but does not inherently improve the performance of visual rendering for the data that is visible, and can even add a slight overhead.
• C. Replacing default visuals with custom visuals can often decrease performance, as custom visuals may be less optimized or more resource-intensive than native visuals, exacerbating the problem.
• D. Increasing the number of times the dataset is refreshed affects data freshness, not the rendering performance of the visuals or the interaction speed with the already loaded data.

Concept tested. Power BI report performance optimization

Reference. https://learn.microsoft.com/en-us/power-bi/guidance/report-design-top-10-performance-considerations

No community discussion yet for this question.