Microsoft Certified Data Analyst Associate Analyzing Data with Microsoft Power BI 2

Question 1

Which Power BI feature allows you to ask natural language questions about your data and get visual answers?

Accepted Answer

Q&A

Answer

Q&A lets users type natural language questions and Power BI returns an appropriate visualization based on the data model.

Question 2

A report has a slicer for 'Year' and a bar chart. You want the chart to ignore the slicer filter. What should you configure?

Accepted Answer

Edit interactions and set the slicer to have no filter on the chart

Answer

In Power BI, you can use Edit Interactions to control how visuals interact, including setting a slicer to have no filter effect on specific visuals.

Question 3

What does the USERELATIONSHIP function do in DAX?

Accepted Answer

Activates an inactive relationship for use within a specific calculation

Answer

USERELATIONSHIP activates an inactive relationship between two columns for the duration of a specific DAX expression.

Question 4

Which aggregation function in Power BI would you use to count only the distinct values in a column?

Accepted Answer

DISTINCTCOUNT

Answer

DISTINCTCOUNT counts the number of unique non-blank values in a column, ignoring duplicates.

Question 5

You need to display the percentage each product contributes to total sales. Which DAX pattern accomplishes this?

Accepted Answer

SUM(Sales[Amount]) / CALCULATE(SUM(Sales[Amount]), ALL(Products))

Answer

Using CALCULATE with ALL removes the product filter context so the denominator returns total sales across all products.

Microsoft Certified Data Analyst Associate Practice Test