Microsoft Certified Data Analyst Associate Data Visualization and Reports in Power BI 2

Question 1

What is the purpose of the drill-through feature in Power BI reports?

Accepted Answer

To navigate to a detail report page filtered to a selected data point

Answer

Drill-through allows users to right-click a data point and navigate to a separate detail page that is automatically filtered to that specific context.

Question 2

In Power BI, what is the key difference between cross-highlighting and cross-filtering between visuals?

Accepted Answer

Cross-filtering removes unrelated data from other visuals; cross-highlighting keeps all data visible but dims unrelated items

Answer

Cross-filtering removes non-selected data from other visuals entirely, while cross-highlighting keeps all data visible but dims items not related to the selection.

Question 3

Which Power BI feature allows you to design a custom tooltip that appears when a user hovers over a data point in a visual?

Accepted Answer

Report page tooltip

Answer

Report page tooltips let you design an entire report page that appears as a rich, custom tooltip when users hover over data points in visuals.

Question 4

What does the 'Sync Slicers' feature in Power BI accomplish?

Accepted Answer

It synchronizes a slicer's selected value across multiple report pages

Answer

Sync Slicers ensures that when a user changes a slicer on one page, the same filter is applied to visuals on other synced pages in the same report.

Question 5

Which Power BI visual type always shows category proportions that sum to 100% by normalizing all bars?

Accepted Answer

100% stacked bar chart

Answer

The 100% stacked bar chart normalizes all values so each bar represents 100%, making relative proportions directly comparable across groups.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Data Visualization and Reports in Power BI 2