Relationship cardinality in Power BI defines how data in two tables relate — One-to-One, One-to-Many, or Many-to-Many. Cross-filter direction controls how filters propagate between tables: either in a single direction or in both directions. Understanding these concepts ensures accurate filtering, optimal model performance, and correct visualisation results.
Time limit: 0
Quiz Summary
0 of 15 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
What does relationship cardinality define in Power BI?
Correct
Incorrect
Question 2 of 15
2. Question
Which cardinality type is most common in Power BI models?
Correct
Incorrect
Question 3 of 15
3. Question
What does the asterisk (*) represent in a relationship diagram?
Correct
Incorrect
Question 4 of 15
4. Question
Which cardinality type requires both sides to have unique values?
Correct
Incorrect
Question 5 of 15
5. Question
What does “cross filter direction” control?
Correct
Incorrect
Question 6 of 15
6. Question
Which cross filter direction is recommended for most star schema models?
Correct
Incorrect
Question 7 of 15
7. Question
When is “Both” cross filter direction useful?
Correct
Incorrect
Question 8 of 15
8. Question
What is the main drawback of using “Both” cross filter direction in large models?
Correct
Incorrect
Question 9 of 15
9. Question
In One-to-Many relationships, which side typically has the unique values?
Correct
Incorrect
Question 10 of 15
10. Question
What is a scenario for Many-to-Many relationships?
Correct
Incorrect
Question 11 of 15
11. Question
What is the default cross filter direction when creating relationships in Power BI?
Correct
Incorrect
Question 12 of 15
12. Question
How can you change cross filter direction in Power BI?
Correct
Incorrect
Question 13 of 15
13. Question
Which cross filter direction can help resolve certain DAX calculation issues involving multiple tables?
Correct
Incorrect
Question 14 of 15
14. Question
What is the purpose of cardinality in relationship creation?
Correct
Incorrect
Question 15 of 15
15. Question
What symbol in Power BI relationships represents the one side?
Correct
Incorrect
Summary
These Relationship Cardinality and Cross Filter Direction MCQs cover key concepts like One-to-One, One-to-Many, Many-to-Many, and Single vs Both filtering. Mastering these ensures accurate filtering, prevents ambiguity, and optimises Power BI data modelling for performance and clarity.
At QuizOrbit, our team specializes in fun, informative quizzes across topics like general knowledge, technology, and entertainment. Boost your knowledge with our expert-designed quizzes.
