Analyzing Data with Microsoft Power BI Flashcards
7 cards from real Microsoft Certified Data Analyst Associate practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Analyzing Data with Microsoft Power BI flashcards as text
Which Power BI visual is best for showing how a value increases and decreases over a series of steps to reach a final result?
Answer: Waterfall chart
A waterfall chart shows the cumulative effect of sequentially introduced positive or negative values, making it ideal for showing contributions to a total.
You need a measure that calculates the running total of sales for the current year up to the last date with data. Which DAX function is most appropriate?
Answer: TOTALYTD
TOTALYTD evaluates a measure over a year-to-date period, automatically respecting the last date with data in the current filter context.
A report consumer wants to save a specific view of a report with particular slicers set. Which Power BI feature supports this?
Answer: Bookmarks
Bookmarks capture the current state of a report page including filter and slicer selections, allowing users to save and return to that specific view.
What happens to a Power BI report when the underlying dataset schema changes and a field used in a visual is removed?
Answer: The visual shows an error indicating a missing field
When a field referenced by a visual is removed from the dataset, that visual displays an error icon indicating the missing field, while other visuals continue to function normally.
Which Power BI service feature allows you to embed a report into a secure internal SharePoint Online page?
Answer: Embed in SharePoint Online
The 'Embed in SharePoint Online' feature generates a secure embed code that can be added to SharePoint Online pages, requiring users to authenticate with their organizational accounts.
What is the function of the decomposition tree visual in Power BI?
Answer: Allows AI-powered or manual exploration of a metric by breaking it down across multiple dimensions
The decomposition tree visual lets users drill into a measure by splitting it across dimensions interactively, with an AI splits option to automatically find the most influential factors.
In Power BI, what is a 'perspective' in a tabular model and how does it benefit report authors?
Answer: A perspective is a subset of model objects (tables, columns, measures) that simplifies the field list for a specific use case
Perspectives define a focused view of the model by exposing only relevant tables and fields, reducing complexity for report authors working on a specific subject area.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com — Passing score, renewal, fees, time limit, score validity, retake fee, exam information · verified Oct 2026
- pearsonvue.com — Test delivery · verified Oct 2026