nerdexam
Microsoft

DP-500 · Question #32

You are optimizing a Power BI data model by using DAX Studio. You need to capture the query events generated by a Power BI Desktop report. What should you use?

The correct answer is C. an All Queries trace. To capture all query events from a Power BI Desktop report using DAX Studio, you should utilize the 'All Queries' trace.

Implement and manage data models

Question

You are optimizing a Power BI data model by using DAX Studio. You need to capture the query events generated by a Power BI Desktop report. What should you use?

Exhibit

DP-500 question #32 exhibit

Options

  • Athe DMv list
  • Ba Query Plan trace
  • Can All Queries trace
  • Da Server Timings trace

How the community answered

(44 responses)
  • A
    2% (1)
  • B
    2% (1)
  • C
    95% (42)

Why each option

To capture all query events from a Power BI Desktop report using DAX Studio, you should utilize the 'All Queries' trace.

Athe DMv list

The DMVs list provides metadata and server status, but does not actively capture ongoing query events.

Ba Query Plan trace

A Query Plan trace shows the execution plan for a single, specific DAX query, not all queries generated by the report.

Can All Queries traceCorrect

The 'All Queries' trace in DAX Studio is specifically designed to capture every DAX query and related event that Power BI Desktop sends to the underlying Analysis Services data model. This comprehensive trace includes queries generated by visuals, filters, and background processes, making it essential for thorough report optimization.

Da Server Timings trace

A Server Timings trace provides detailed timing for a single query, breaking down formula and storage engine time, but it does not capture all queries generated by the report.

Concept tested: DAX Studio tracing features

Source: https://dax.studio/features/tracing/

Topics

#DAX Studio#Power BI optimization#Query tracing#Performance monitoring

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice