Power BI 778 Data Modeling in Power BI 2

Question 1

What is a calculated column in Power BI?

Accepted Answer

A column computed during query refresh using DAX

Answer

A calculated column uses a DAX expression evaluated row-by-row and stored in the model during data refresh.

Question 2

What is the purpose of a measure in Power BI?

Accepted Answer

To calculate aggregated values dynamically based on filter context

Answer

Measures are DAX calculations that evaluate dynamically based on the filters and context applied in a report.

Question 3

In Power BI, which view allows you to see the raw data stored in each table?

Accepted Answer

Data view

Answer

Data view displays the actual rows and columns of data stored in each table of your Power BI model.

Question 4

What happens when you mark a table as a 'Date Table' in Power BI?

Accepted Answer

It enables built-in time intelligence functions to work correctly

Answer

Marking a table as a Date Table ensures Power BI's time intelligence DAX functions use that table's date column correctly.

Question 5

Which relationship cardinality is most common in a star schema Power BI model?

Accepted Answer

One-to-many

Answer

One-to-many is the most common cardinality, where one dimension row relates to many fact table rows.

Power BI 778 Practice Test