Resolving many-to-many with a bridge table
Marketing wants a card in SM_RetailSales showing which customers
enrolled in each promotion, and Customers must keep one row per customer.
Select each design and compare the card's "This design shows" row with its "Should show" row.
Which design meets both requirements?
This exercise is part of the course
Data Ingestion and Semantic Models with Microsoft Fabric
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise