nerdexam
Microsoft

DP-500 · Question #29

You open a Power BI Desktop report that contains an imported data model and a single report page. You open Performance analyzer, start recording, and refresh the visuals on the page. The recording…

The correct answer is D. When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish. If the 'Other' category is the largest component of load time for visuals refreshed simultaneously in Performance analyzer, it indicates that visuals spend most time waiting for other processes to finish.

Explore and visualize data

Question

You open a Power BI Desktop report that contains an imported data model and a single report page. You open Performance analyzer, start recording, and refresh the visuals on the page. The recording produces the results shown in the following exhibit. [Image of Performance analyzer] What can you identify from the results?

Options

  • AThe Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.
  • BThe Actual/Forecast Billable Hrs YTD visual displays the most data.
  • CUnoptimized DAX queries cause the page to load slowly.
  • DWhen all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.

How the community answered

(49 responses)
  • A
    4% (2)
  • B
    12% (6)
  • C
    2% (1)
  • D
    82% (40)

Why each option

If the 'Other' category is the largest component of load time for visuals refreshed simultaneously in Performance analyzer, it indicates that visuals spend most time waiting for other processes to finish.

AThe Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.

This statement focuses on a specific visual and scenario, which cannot be concluded as the primary issue without detailed analysis of all visual breakdowns, especially if 'Other' time is broadly dominant.

BThe Actual/Forecast Billable Hrs YTD visual displays the most data.

Performance analyzer shows time durations, not the volume of data displayed by a visual.

CUnoptimized DAX queries cause the page to load slowly.

While unoptimized DAX queries can slow pages, if 'Other' time is the largest factor, the primary bottleneck is likely waiting for concurrent processes, not solely inefficient DAX.

DWhen all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.Correct

In Power BI's Performance analyzer, the 'Other' category represents time spent waiting for other operations or processes to complete when multiple visuals are refreshing concurrently. If this time is significant across many visuals, it suggests that contention or sequential processing is the primary bottleneck, rather than individual visual rendering or DAX query execution.

Concept tested: Interpreting Performance Analyzer results

Source: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

Topics

#Performance Analyzer#Power BI Performance#Report Optimization#Visual Refresh

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-500 Practice