Microsoft Certified Data Analyst Associate Data Visualization and Reports in Power BI

Question 1

Which Power BI visual type is best suited for displaying trends over a continuous time period?

Accepted Answer

Line chart

Answer

Pie chart

Answer

Treemap

Answer

Funnel chart

Question 2

What is the primary purpose of slicers in Power BI reports?

Accepted Answer

To filter data visually on a report page

Answer

To create calculated columns in the data model

Answer

To merge multiple tables together

Answer

To schedule automatic data refresh

Question 3

In Power BI, what does 'cross-filtering' between visuals mean?

Accepted Answer

Selecting data in one visual automatically filters other visuals on the same page

Answer

Filtering data from external sources into the report

Answer

Applying filters from one page to all other report pages

Answer

Creating filter expressions in DAX that span multiple tables

Question 4

Which Power BI visual is most appropriate for displaying a single aggregated key metric prominently?

Accepted Answer

Card visual

Answer

Matrix visual

Answer

Scatter chart

Answer

Waterfall chart

Question 5

What is a KPI visual used for in Power BI?

Accepted Answer

Tracking a key metric's performance against a defined target value

Answer

Comparing multiple dimensions side by side

Answer

Showing geographic distribution of data across a map

Answer

Displaying hierarchical relationships between categories

Question 6

In Power BI Desktop, which ribbon option allows you to configure how visuals interact with each other on a report page?

Accepted Answer

Format ribbon > Edit interactions

Answer

View ribbon > Page view

Answer

Modeling ribbon > New parameter

Answer

File > Options and settings

Question 7

Which Power BI chart type displays hierarchical data as nested rectangles where each rectangle's size represents its proportional value?

Accepted Answer

Treemap

Answer

Donut chart

Answer

Gauge chart

Answer

Funnel chart