Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 9

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?

Answer options

• A. the DMV list
• B. a Server Timings trace
• C. an All Queries trace
• D. a Query Plan trace

Correct answer: C

Explanation

The correct answer is C, as an All Queries trace captures all the query events generated by the report, which is essential for optimization. The other options, such as the DMV list and Server Timings trace, do not provide the complete set of query events needed for this specific optimization task.