Configure a semantic model

What is the primary function of relationships in a Power BI model?

They propagate filters from one table to another

In Power BI, what happens if you filter the Year column in the Date table?

The filter automatically applies to the Sales table if a relationship exists

True or False:

Relationships in Power BI only work in one direction and cannot propagate through multiple tables.

False

When your model comprises more than one table, you must configure ___ to ensure filters propagate correctly.

Relationships

True or False:

For report authors, the automatic filtering of related tables is considered unusual behavior and usually avoided.

False

Why might you adjust Power BI Desktop Data load options before loading data?

To control how relationships are imported, updated, or autodetected

What can happen if relationship settings are enabled in Data load options?

Relationships in source data can be imported and updated

True or False:

Disconnected tables are always considered errors in a Power BI model and should be avoided.

False

When relationships aren’t automatically created, you can establish them in the ___ window or in Model view.

Manage relationships

What is a disconnected table most useful for?

Supporting what-if scenarios or field parameters

In a relationship, each connection is defined by:

A single "from" column and a single "to" column

Why must the "from" column on the one-side of a relationship contain unique values?

To properly enforce one-to-many relationships

True or False:

Power BI automatically supports multi-column keys for relationships without transformation.

False

If the related column data types don’t match, you can adjust them using ___ .

Power Query

When dealing with a multi-column key in a data source, what must you do before creating the relationship?

Transform the data to produce a single-column key

Which of the following is the most common cardinality type in Power BI models?

One-to-many (1:)

True or False:

A One-to-one (1:1) relationship is often preferred over merging queries in Power Query.

False

In a star schema design, dimension tables typically appear on which side of the relationship?

The one side

When Power BI Desktop automatically creates a relationship, it determines the cardinality based on ___ .

The values already loaded into the columns

In which scenario would a Many-to-many (:) relationship be most appropriate?

Relating a dimension at SKU level with a target table at Category level

Why is One-to-one (1:1) cardinality uncommon?

Because it usually indicates the tables should be merged

True or False:

One-to-many and Many-to-one cardinality types are fundamentally different in how they propagate filters.

False

A cardinality that allows you to relate two tables that each have a unique column.

One-to-one (1:1)

The most common cardinality type in Power BI, typically used between dimension and fact tables in a star schema.

One-to-many (1:)

A cardinality useful when there isn’t a column of unique values, such as relating Product Category to Target Category.

Many-to-many (:)

In a star schema design, dimension tables are usually found on which side of the relationship?

The one side

In a one-to-many (or many-to-one) relationship, the possible cross filter directions are:

Single or both

In a one-to-one relationship, the cross filter direction is always:

Both

Which relationship type allows cross filtering as single to either table, or both?

Many-to-many

Why is it generally recommended to avoid cross filters in both directions?

It reduces query performance and may confuse consumers

What is a valid reason to allow cross filtering of a one-to-many relationship in both directions?

To enable many-to-many analysis between two dimension tables

In the salesperson-region example, what role does the SalespersonRegion table serve?

Bridging table

Between two model tables, how many active filter propagation paths can exist at once?

At most one

How can an inactive relationship be used during a calculation?

USERELATIONSHIP()

When a fact table has multiple date columns (e.g., OrderDate, ShipDate) pointing to one Date table, what is true?

Only one relationship can be active; the other must be inactive

What’s the standard modeling approach to filter by Order Date and Ship Date independently without toggling relationships?

Create two separate Date tables (role-playing dimensions)

In diagrams, how are active vs. inactive relationships typically indicated?

Active solid; inactive dotted

What best describes a role-playing dimension in Power BI?

A dimension reused for multiple roles, like Order Date and Ship Date

True or False:

An inactive relationship can never be used in measures or calculations.

False

True or False:

USERELATIONSHIP can temporarily activate a specific inactive path during measure evaluation.

True

True or False:

To enable simultaneous filtering by Order Date and Ship Date without DAX, you should duplicate the Date table for each role.

True

True or False:

You can have two active relationships between the same pair of tables if both columns are unique keys.

False

In the Power BI model diagram, relationships are represented by the ____ that connect tables.

Lines

An easy way to create a relationship in the model diagram is to ____ between tables.

Drag and drop columns

The cardinality of a relationship is described by the ____ icons at the ends of the relationship line.

One (1) or Many (*)

In the model diagram, an active relationship is shown as a ____, while an inactive relationship is shown as a ____.

Solid line / Dotted line

The cross filter direction of a relationship is described by the ____ located in the middle of the relationship line.

Arrows

When your model has required tables, columns, and relationships, you can enhance the design by configuring properties of model objects such as ____.

Tables and columns

The easiest place to work with table properties in Power BI Desktop is the ____, since it supports multi-select and bulk updates.

Model view with the Properties pane

A model table’s ____ property is inherited from the Power Query query name but can be renamed in Power BI Desktop.

Name

Which property allows you to provide a detailed definition of a table, shown when report authors hover their cursor over the table?

Description

The ____ property allows you to set alternative names for a table, so that Q&A or Copilot can better interpret user requests.

Synonyms

True or False:

Hiding a model table removes it completely from the model, making it unusable in reports.

False

A table that should often be hidden from report authors is a ____, such as the SalespersonRegion table used in many-to-many relationships.

Bridging table

By default, Power BI includes an ____ feature that automatically creates hidden date tables for each column with a date or date/time data type.

Auto date/time

True or False:

The Auto date/time feature is considered a best practice for professional modeling and should always be left enabled.

False

Instead of using Auto date/time, a best practice is to use an existing source date table or create a calculated table with ____.

DAX

Each date table in a model should contain a column of ____, which must be marked as the date column.

Date values

Marking a date table ensures that ____ functions return correct results.

Time intelligence (DAX)

Power BI validates marked date columns to ensure they contain ____ values, no BLANKs, and contiguous ranges.

Unique

Column names must be ____ within the same model table.

Unique

True or False:

If you change a column name in Power BI Desktop, Power Query automatically appends a step to modify the column name there.

True

Columns used by relationships, especially when based on non-meaningful key values, are often set to ____ to avoid clutter in the model.

Hidden

Assigning columns to a ____ can help organize many visible fields in a table.

Display folder

Every column has a ____ property inherited from Power Query that determines how values are stored.

Data type

True or False:

The Format property controls how column values are stored in the model.

False

A fixed decimal number column could be formatted as a ____ in visuals.

Currency

Text values in Power BI naturally sort ____ by default.

Alphabetically

True or False:

Number and date columns naturally sort from smallest (or earliest) to largest (or latest) by default.

True

When a column’s natural sort order doesn’t meet requirements, you can refer to a ____ in the same table to sort it.

Column containing suitable sort values

In a Date table, the Month column with values like "2017 Aug" sorts incorrectly because it is ____ by default.

Alphabetical

To fix the sort order of the Month column, you should set the ____ property to use a numeric MonthKey column.

Sort by Column

True or False:

After using a MonthKey column to sort the Month column, the MonthKey column should typically be hidden from report authors.

True

The ____ property describes the content of a column in Power BI.

Data category

True or False:

Setting the Data category is especially useful for columns that store spatial values, either as text or decimal latitude/longitude.

True

Columns categorized as spatial values appear in the Data pane with a ____ icon.

Spatial/geography

When a column contains a URL to a website, the Data category should be set to ____.

Web URL

True or False: Image URLs in a column can be visualized in table, matrix, slicer, or multi-row card visuals once the Data category is set correctly.

True

When the URL contains a general web link, Power BI can condense it into a compact icon in ____ or matrix visuals.

Table

The ____ property determines how numeric columns summarize by default in Power BI.

Summarize by

True or False:

Options for the Summarize by property include Sum, Min, Max, Average, Count, Distinct Count, and None.

True

Columns that can be summarized appear in the Data pane with a ____ symbol.

Ʃ

True or False:

Report authors cannot change the summarization of a column once the Summarize by property is set.

False

If you do not want a numeric column to be summarized by default, you should set the Summarize by property to ____.

None

Are optional structures that provide clues to report authors about relationships between columns in a table.

Hierarchies

True or False:

If you don't create a hierarchy, report authors cannot achieve the same results by adding multiple columns to a visual.

False

A hierarchy must be based on columns from the ____ table.

The table it belongs to

True or False:

You can add more than one hierarchy to a single model table.

True

When report authors need complex summarizations, such as year-to-date (YTD) calculations, they must create a ____.

Measure

True or False:

A measure is a named DAX formula added to a model table that appears in the Data pane with a calculator icon.

True

Measure names must be ____ within the model.

Unique

Measures can be ____ or complex.

Simple

True or False:

Measures extend the data in your semantic model by providing essential calculations that help uncover deeper insights and trends.

True

True or False:

If the model is queried using MDX (for example, Analyze in Excel), measures must also be created.

True

If you don't have DAX skills, you can generate a measure using ____ or Quick measures.

Copilot for Power BI

Quick measures allow you to create a measure by selecting a ____ and dragging fields to configure it.

Calculation template

True or False:

Power BI Desktop automatically creates a measure based on your Quick Measure configuration.

True

The Home table property allows you to assign a Quick Measure to:

Any model table

True or False:

You can set formatting properties for Quick Measures.

True

A parameter in Power BI lets users change ____ without changing the original data.

Report settings