Exam DP-600 topic 1 question 88 discussion

Actual exam question from Microsoft's DP-600

Question #: 88
Topic #: 1

DRAG DROP
-

You have a Fabric tenant that contains a Microsoft Power BI report named Report1.

Report1 is slow to render. 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 five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Show Suggested Answer

Suggested Answer:

by 554b579 at April 6, 2024, 1:16 a.m.

Comments

Submit Cancel

554b579

Highly Voted 1 year ago

Good Video: https://www.youtube.com/watch?v=C5HBhlLUFsE&t=176s From performance analyzer capture code. Sort duration descending by DAX query time. Copy the first query over to Dax Studio Enable query and server timings and run the query View Server timings

upvoted 48 times

...

calvintcy

Highly Voted 10 months, 3 weeks ago

I took the test today, and this question was included. The options 'Sort the Duration (ms) column in descending order' was not there. Hence the answer: -From Performance analyzer, capture a recording. -Sort the Duration (ms) column in descending order by DAX query time. -Copy the first query to Dax Studio. -Enable Query Timings and Server Timings. Run the query. -View the Server Timings tab.

upvoted 14 times

...

AbhiShar

Most Recent 6 months, 3 weeks ago

From Performance analyzer, capture a recording - This will start recording the performance of the report. Enable Query Timings and Server Timings. Run the query - This step captures detailed timings of the query execution on both the formula engine and storage engine. View the Query Timings tab - Here you can analyze how long the query takes in different phases of execution. Sort the Duration (ms) column in descending order by DAX query time - This will help identify the slowest DAX query. Copy the first query to DAX Studio - Once the slowest query is identified, you can further analyze it using DAX Studio for optimization.

upvoted 1 times

...

stilferx

11 months, 3 weeks ago

IMHO, 1. Start Recording 2. Sort in descending order 3. Copy to DAX studio (the problematic query) 4. Enable query t and server t (to gather additional info) 5. View Server Timings (to understand it is storage engine or formula engine) It is taken from the YouTube video below.

upvoted 3 times

...

hello2tomoki

1 year ago

Here are the steps you should follow to identify the slowest DAX query and review how long the query spends in the formula engine compared to the storage engine: 1.Open the report in Power BI Desktop. Go to the 'View' tab and click on 'Performance Analyzer' and Click on 'Start Recording', then 'Refresh Visuals' 2.Review the DAX query and duration in the performance analyzer pane. Sort the Duration (ms) column in descending order 3.Copy the first query to DAX Studio 4.In DAX Studio, enable Query Timings and Server Timings. Run the query 5.View the Server Timings tab to see data for the formula engine (FE) and the storage engine (SE)