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 column imported from a CSV file

Answer

A column created in Power Query

Answer

A column from a live database view

Question 2

What is the purpose of a measure in Power BI?

Accepted Answer

To calculate aggregated values dynamically based on filter context

Answer

To store a static value in a table

Answer

To define table relationships

Answer

To set row-level security rules

Question 3

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

Accepted Answer

Data view

Answer

Report view

Answer

Model view

Answer

Query editor

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

It hides the table from the report canvas

Answer

It converts all columns to date format

Answer

It automatically creates a calendar hierarchy

Question 5

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

Accepted Answer

One-to-many

Answer

Many-to-many

Answer

One-to-one

Answer

Many-to-one

Question 6

What is the VertiPaq engine in Power BI?

Accepted Answer

An in-memory columnar storage engine used for Import mode

Answer

A query language for DirectQuery

Answer

A visualization rendering engine

Answer

A cloud gateway service