Microsoft Certified Data Analyst Associate Analyzing Data with Microsoft Power BI 5

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?

Accepted Answer

Waterfall chart

Answer

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?

Accepted Answer

TOTALYTD

Answer

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?

Accepted Answer

Bookmarks

Answer

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?

Accepted Answer

The visual shows an error indicating a missing field

Answer

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?

Accepted Answer

Embed in SharePoint Online

Answer

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.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Analyzing Data with Microsoft Power BI 5