Microsoft Certified Data Analyst Associate Azure Data Analyst Associate 2

Question 1

In Power BI, which DAX function returns the current row context value from a related table?

Accepted Answer

RELATED()

Answer

RELATED() traverses a many-to-one relationship to fetch a column value from the related table in the current row context.

Question 2

A data analyst needs to schedule automatic dataset refresh in Power BI Service. What is the maximum number of daily refreshes allowed on a Power BI Pro license?

Accepted Answer

8

Answer

Power BI Pro allows up to 8 scheduled refreshes per day per dataset.

Question 3

Which Power BI feature allows you to define reusable data transformation logic that can be called from multiple queries?

Accepted Answer

Custom Functions

Answer

Custom Functions in Power Query allow you to encapsulate transformation steps and invoke them across multiple queries.

Question 4

When using DirectQuery mode in Power BI, which of the following is a known limitation?

Accepted Answer

Calculated tables are not supported

Answer

Calculated tables are not supported in DirectQuery mode because they require data to be stored in the model, which DirectQuery does not do.

Question 5

An analyst wants to compare sales performance against a dynamic benchmark that changes based on slicer selection. Which DAX function is most appropriate?

Accepted Answer

SELECTEDVALUE()

Answer

SELECTEDVALUE() returns the value of a column when the context contains exactly one distinct value, making it ideal for capturing slicer selections.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Azure Data Analyst Associate 2