Microsoft Power BI Microsoft Power BI 3

Question 1

Which DAX function evaluates an expression in a context modified by filters?

Accepted Answer

CALCULATE

Answer

CALCULATE changes the filter context in which an expression is evaluated.

Question 2

What type of relationship cardinality is most common between a dimension and a fact table?

Accepted Answer

One-to-many

Answer

Star schemas typically use one-to-many relationships from dimension to fact tables.

Question 3

Which Power BI object refreshes scheduled data from on-premises sources?

Accepted Answer

On-premises data gateway

Answer

The on-premises data gateway enables scheduled refresh from local data sources to the service.

Question 4

What does a measure differ from a calculated column in terms of evaluation?

Accepted Answer

Measures evaluate at query time based on context

Answer

Measures are calculated dynamically at query time according to the current filter context.

Question 5

Which view in Power BI Desktop lets you manage relationships between tables?

Accepted Answer

Model view

Answer

Model view displays tables and lets you create or edit relationships visually.

Microsoft Power BI Practice Test