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

Question 1

A time intelligence function like SAMEPERIODLASTYEAR requires what in order to work correctly?

Accepted Answer

A continuous date table marked as a date table

Answer

Time intelligence functions require a contiguous date table with no gaps that has been marked as a date table in the model.

Question 2

Which visual in Power BI is specifically designed to display hierarchical data as nested rectangles sized by value?

Accepted Answer

Treemap

Answer

A treemap displays hierarchical data as a set of nested rectangles where the size of each rectangle represents the value of that category.

Question 3

You want to prevent report users from seeing the underlying data by right-clicking a visual. Which feature should you configure?

Accepted Answer

Disable 'See data' in visual options

Answer

You can disable the 'See data' and 'Export data' options per visual in the visual's header icons or at the report level in settings.

Question 4

What is the difference between a calculated column and a measure in Power BI?

Accepted Answer

Calculated columns are stored row by row in the table; measures are evaluated dynamically at query time

Answer

Calculated columns are computed during data refresh and stored in the model row by row, while measures are computed dynamically based on the current filter context when a visual is rendered.

Question 5

In a Power BI report, which filter scope applies only to a single visual and does not affect other visuals on the page?

Accepted Answer

Visual-level filter

Answer

Visual-level filters in the Filters pane apply only to the specific visual they are set on, leaving other visuals unaffected.

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 3