Microsoft Certified Data Analyst Associate Microsoft DA-100 2

Question 1

In Power BI, which DAX function returns the value of the last non-blank row in a column?

Accepted Answer

LASTNONBLANK

Answer

LASTNONBLANK iterates a table and returns the last value where the expression is not blank.

Question 2

A Power BI report uses a many-to-many relationship between two tables. What is the recommended approach to resolve this?

Accepted Answer

Create a bridge table and use two one-to-many relationships

Answer

A bridge (junction) table decomposes a many-to-many into two one-to-many relationships, preserving filter direction control.

Question 3

Which Power BI service feature allows you to schedule a dataset refresh up to 48 times per day?

Accepted Answer

Incremental refresh

Answer

Incremental refresh with a real-time data option in Power BI Premium enables up to 48 refreshes per day.

Question 4

When using Power Query, what is the purpose of the 'Table.Buffer' function?

Accepted Answer

Caches a table in memory to prevent repeated evaluation

Answer

Table.Buffer forces immediate evaluation and caches the table in memory, preventing downstream steps from re-evaluating it repeatedly.

Question 5

In Power BI Desktop, which view is used to define and manage relationships between tables?

Accepted Answer

Model view

Answer

Model view (previously called Relationships view) displays all tables and their relationships visually, allowing you to create, edit, and delete them.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Microsoft DA-100 2