Microsoft Certified Data Analyst Associate Microsoft DA-100 5

Question 1

You need to show the percentage contribution of each product to total sales, regardless of what is selected in a slicer. Which DAX pattern achieves this?

Accepted Answer

Sales / CALCULATE(Sales, ALL(Products))

Answer

Dividing by CALCULATE(Sales, ALL(Products)) removes the product filter, returning sales for all products as the denominator regardless of slicer selection.

Question 2

Which Power Query step type is responsible for combining rows from two tables with identical column structures?

Accepted Answer

Append queries

Answer

Append queries stacks rows from two or more tables with the same columns, equivalent to a SQL UNION ALL operation.

Question 3

In DAX, what is the correct syntax to create a calculated column that returns the sales amount from a related table?

Accepted Answer

RELATED(Sales[Amount])

Answer

RELATED traverses an existing many-to-one relationship to retrieve a scalar value from a related table's column.

Question 4

A Power BI report is embedded in a custom web application for external customers who do not have Power BI licenses. Which embedding approach is required?

Accepted Answer

Embed for your customers (app owns data) using a service principal

Answer

'Embed for your customers' uses a service principal or master account to authenticate on behalf of users who have no Power BI license, requiring Power BI Embedded (Azure) capacity.

Question 5

Which Power BI Desktop feature lets you write Python or R scripts to transform data in Power Query?

Accepted Answer

Script transform step (Run Python/R Script in Power Query)

Answer

Power Query supports 'Run Python Script' and 'Run R Script' transform steps that pass the current table to a script and return the result as a new table.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Microsoft DA-100 5