Microsoft Certified Data Analyst Associate Analyzing Data with Microsoft Power BI 5 — Questions and Answers
Question 1: Which Power BI visual is best for showing how a value increases and decreases over a series of steps to reach a final result?
- Area chart
- Waterfall chart (Correct answer)
- Ribbon chart
- Combo chart
Correct 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.
Question 2: 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?
- TOTALYTD (Correct answer)
- DATESYTD
- DATESBETWEEN
- DATESINPERIOD
Correct answer: TOTALYTD
TOTALYTD evaluates a measure over a year-to-date period, automatically respecting the last date with data in the current filter context.
Question 3: A report consumer wants to save a specific view of a report with particular slicers set. Which Power BI feature supports this?
- Pinned visuals
- Bookmarks (Correct answer)
- Report themes
- Perspectives
Correct 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.
Question 4: What happens to a Power BI report when the underlying dataset schema changes and a field used in a visual is removed?
- Power BI automatically replaces the missing field with a similar one
- The visual shows an error indicating a missing field (Correct answer)
- The report fails to open entirely
- Power BI reverts to the last saved schema
Correct 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.
Question 5: Which Power BI service feature allows you to embed a report into a secure internal SharePoint Online page?
- Publish to web
- Embed in SharePoint Online (Correct answer)
- Export to PDF
- Power BI Embedded
Correct 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.
Question 6: What is the function of the decomposition tree visual in Power BI?
- Displays a fixed hierarchy of categories as nested rectangles
- Allows AI-powered or manual exploration of a metric by breaking it down across multiple dimensions (Correct answer)
- Shows the proportion of each category relative to a parent category
- Compares multiple measures across a single dimension
Correct 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.
Question 7: In Power BI, what is a 'perspective' in a tabular model and how does it benefit report authors?
- A perspective is a saved filter that restricts rows in a table
- A perspective is a subset of model objects (tables, columns, measures) that simplifies the field list for a specific use case (Correct answer)
- A perspective is a visual theme applied to all reports using the dataset
- A perspective is an alternative name for a calculated table
Correct 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.
Microsoft Certified Data Analyst Associate Analyzing Data with Microsoft Power BI 5
Which Power BI visual is best for showing how a value increases and decreases over a series of steps to reach a final result?