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

To export summarized data to an Excel spreadsheet

Answer

To refresh the underlying data model manually

Answer

To embed a Power BI report in another application

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-highlighting removes unrelated data; cross-filtering keeps all data but dims unrelated items

Answer

Cross-highlighting applies only to bar charts; cross-filtering applies to all visual types

Answer

They perform identical operations but use different syntax

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

Bookmarks feature

Answer

Smart Narrative visual

Answer

Q&A visual

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

It connects slicers from different Power BI reports together

Answer

It schedules automatic slicer value updates based on the current date

Answer

It links a slicer to an external data source for real-time filtering

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

Clustered bar chart

Answer

Waterfall chart

Answer

Ribbon chart

Question 6

What is the 'Smart Narrative' visual in Power BI designed to automatically generate?

Accepted Answer

Written natural language text summaries of key data insights

Answer

Future data trend predictions using machine learning models

Answer

Animated transitions between report pages

Answer

Custom DAX measures built from natural language descriptions

Question 7

What is the primary use of bookmarks in Power BI?

Accepted Answer

To capture and save the current state of a report page for navigation or storytelling

Answer

To save database connection strings for data sources

Answer

To mark specific rows in the data model for later reference

Answer

To schedule when report subscriptions are sent to users