nerdexam
Microsoft

DP-500 · Question #76

Which two possible tools can you use to identify what causes the report to render slowly? Each correct answer presents a complete solution.

The correct answer is B. DAX Studio. To identify the root cause of slow report rendering, utilize Performance Analyzer in Power BI Desktop and DAX Studio to diagnose visual and DAX query performance.

Implement and manage data models

Question

Which two possible tools can you use to identify what causes the report to render slowly? Each correct answer presents a complete solution.

Options

  • ASynapse Studio
  • BDAX Studio
  • CAzure Data Studio
  • DPerformance analyzer in Power BI Desktop

How the community answered

(41 responses)
  • A
    2% (1)
  • B
    78% (32)
  • C
    15% (6)
  • D
    5% (2)

Why each option

To identify the root cause of slow report rendering, utilize Performance Analyzer in Power BI Desktop and DAX Studio to diagnose visual and DAX query performance.

ASynapse Studio

Synapse Studio is a web-based tool for Azure Synapse Analytics, used for data warehousing and big data analytics, not for diagnosing Power BI report rendering performance.

BDAX StudioCorrect

DAX Studio is a powerful external tool for Power BI that allows users to analyze, optimize, and troubleshoot DAX queries and data model performance, providing detailed server timings and query plans.

CAzure Data Studio

Azure Data Studio is a cross-platform desktop environment for data professionals using various data platforms, but it does not directly analyze Power BI report rendering performance.

DPerformance analyzer in Power BI Desktop

Concept tested: Power BI report performance analysis tools

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

Topics

#Power BI performance#DAX Studio#Performance Analyzer#Report optimization

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice