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

LASTDATE

Answer

MAXX

Answer

CLOSINGBALANCEYEAR

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

Enable bidirectional cross-filtering on the direct relationship

Answer

Use CROSSFILTER() in every measure

Answer

Convert both tables to calculated tables

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

Enhanced refresh API

Answer

Premium per-user scheduled refresh

Answer

DirectQuery auto-refresh

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

Writes a table to a CSV file

Answer

Converts a table to a binary format

Answer

Limits the table to the first 1,000 rows

Question 5

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

Accepted Answer

Model view

Answer

Report view

Answer

Data view

Answer

Query view

Question 6

A DAX measure needs to calculate revenue only for the previous calendar year. Which time-intelligence function is most appropriate?

Accepted Answer

PREVIOUSYEAR

Answer

SAMEPERIODLASTYEAR

Answer

DATEADD with -1 year

Answer

PARALLELPERIOD with -1 year

Question 7

In Power BI, what does the 'Dual' storage mode for a table mean?

Accepted Answer

The table can behave as either Import or DirectQuery depending on the query context

Answer

The table is replicated across two datasets

Answer

The table stores both row-level and column-level security rules

Answer

The table maintains two versions: one cached, one live