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

You are using DAX Studio to analyze a slow-running report query.
You need to identify inefficient join operations in the query.
What should you review?

Answer options

• A. the query statistics
• B. the query plan
• C. the query history

Correct answer: B

Explanation

The correct answer is B, the query plan, as it provides a detailed view of how the joins are executed, helping to identify inefficiencies. Option A, the query statistics, gives performance metrics but not specific join details, while Option C, the query history, only shows previously executed queries without insights into their performance.