BenchMark Quizzes by MDFT Pro

Identify and Analyze Slow DAX Queries

You have been hired by MDFT Pro, a well-known training agency, to optimize their Power BI reports. The academy’s Fabric tenant contains a Microsoft Power BI report named “Student Performance Dashboard” that is used to track student progress. The dashboard is slow to render, and you suspect that an inefficient DAX query is being executed.

You need to identify the slowest DAX query, and then review how long the query spends in the formula engine as compared to the storage engine.

Which actions should you perform in sequence?

Choose all correct answers from the options below.

Explanations for each answer:

View the Query Timings tab is incorrect. The Query Timings tab is not the first step in analyzing DAX query performance. You need to capture performance data first before viewing any timing information.
From Performance analyzer, capture a recording is correct.
Sort the Duration (ms) column in descending order is incorrect. While sorting by duration is important, you need to specifically sort by DAX query time to identify the slowest DAX queries.
Enable Query Timings and Server Timings. Run the query is incorrect. This step comes after identifying the specific query to analyze. You need to first identify the slowest query before enabling detailed timing analysis.
Sort the Duration (ms) column in descending order by DAX query time is correct.
Copy the first query to DAX Studio is correct.
Enable Query Timings and Server Timings. Run the query is correct.
View the Server Timings tab is correct.

Learn more about using Performance Analyzer in Fabric:

Performance Analyzer

Exam Preparation Quiz

Identify and Analyze Slow DAX Queries