Microsoft Certified Data Analyst Associate Data Visualization and Reports in Power BI 2 — Questions and Answers
Question 1: What is the purpose of the drill-through feature in Power BI reports?
- To navigate to a detail report page filtered to a selected data point (Correct answer)
- To export summarized data to an Excel spreadsheet
- To refresh the underlying data model manually
- To embed a Power BI report in another application
Correct answer: To navigate to a detail report page filtered to a selected data point
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?
- Cross-highlighting removes unrelated data; cross-filtering keeps all data but dims unrelated items
- Cross-filtering removes unrelated data from other visuals; cross-highlighting keeps all data visible but dims unrelated items (Correct answer)
- Cross-highlighting applies only to bar charts; cross-filtering applies to all visual types
- They perform identical operations but use different syntax
Correct answer: Cross-filtering removes unrelated data from other visuals; cross-highlighting keeps all data visible but dims unrelated items
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?
- Bookmarks feature
- Smart Narrative visual
- Report page tooltip (Correct answer)
- Q&A visual
Correct answer: Report page tooltip
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?
- It connects slicers from different Power BI reports together
- It schedules automatic slicer value updates based on the current date
- It synchronizes a slicer's selected value across multiple report pages (Correct answer)
- It links a slicer to an external data source for real-time filtering
Correct answer: It synchronizes a slicer's selected value across multiple report pages
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?
- Clustered bar chart
- Waterfall chart
- 100% stacked bar chart (Correct answer)
- Ribbon chart
Correct answer: 100% stacked bar chart
The 100% stacked bar chart normalizes all values so each bar represents 100%, making relative proportions directly comparable across groups.
Question 6: What is the 'Smart Narrative' visual in Power BI designed to automatically generate?
- Future data trend predictions using machine learning models
- Written natural language text summaries of key data insights (Correct answer)
- Animated transitions between report pages
- Custom DAX measures built from natural language descriptions
Correct answer: Written natural language text summaries of key data insights
Smart Narrative generates natural language text that automatically summarizes key insights, trends, and patterns found in your report data.
Question 7: What is the primary use of bookmarks in Power BI?
- To save database connection strings for data sources
- To mark specific rows in the data model for later reference
- To schedule when report subscriptions are sent to users
- To capture and save the current state of a report page for navigation or storytelling (Correct answer)
Correct answer: To capture and save the current state of a report page for navigation or storytelling
Bookmarks save the current state of a report page — including filters, slicer selections, and visual visibility — and can be used to create navigation or storytelling experiences.
Microsoft Certified Data Analyst Associate Data Visualization and Reports in Power BI 2
What is the purpose of the drill-through feature in Power BI reports?