Cardinality Cross-Filter Quiz

Quiz covering Design and Implement a Data Model

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 1

   In a Power BI relationship with a 'One-to-Many' cardinality, which side of the relationship typically contains the unique identifier or primary key?

2. 2

   You have two tables, 'Sales' and 'Products', connected by a 'ProductKey'. If you set the Cross-filter direction to 'Both', what is the primary risk you might introduce to your data model?

3. 3

   When is it appropriate to use a 'Many-to-Many' cardinality in a Power BI data model?

4. 4

   If you have a 'Date' table and a 'Sales' table, and you want the 'Date' table to filter the 'Sales' table, which cross-filter direction should be used for optimal performance and standard star-schema design?

5. 5

   Consider a model with three tables: 'Customers', 'Orders', and 'Returns'. You want to filter 'Customers' based on 'Returns', but there is no direct relationship. If you enable 'Both' direction on the 'Customers-to-Orders' and 'Orders-to-Returns' relationships, what happens to the filter context?