Learn Power BI

Blog
Practice Questions

Learn Power BI

Accelerate your Career and Get Certified

Work with Relationships and Cardinality

Wednesday, April 7th, 2021

Welcome to your Work with Relationships and Cardinality

Questions are based on this module

Power BI autodetects relationships based on column names

False

True

Which cardinality is not recommended?

Many-to-one

One-to-many

One-to-one

Many-to-many

Which cardinality is a default when relationships are automatically created?

many-to-many

one-to-one

one-to-many

there is no default, you must define the cardinality

With a single cross-filter direction between two tables with a one-to-many relationship, filtering will be done by

Either the "one" or the "many" side can act as the filter, depending on the option selected

The "many" side - the table with multiple values on the relationship column

The "one" side - the table with unique values on the relationship column

Time is Up!

Time's up

One thought on “Work with Relationships and Cardinality”

Lukas Halim says:

April 23, 2021 at 12:04 am

Corrected!

Reply

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.6 Instructor Rating
53,604 Students

14,612 Reviews
2 courses

One thought on “Work with Relationships and Cardinality”

Leave a Reply Cancel reply