Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise