Your company is trying to map suppliers to retail stores in a many-to-many cardinality. Many suppliers can supply to one retail store and many retail stores can be supplied by one supplier. As part of the data source, a linking entity is available.
You need to provide guidance on creating many-to-many relationships for suppliers and retail stores.
What should you recommend?
When dealing with many-to-many relationships, a linking entity is typically used. This linking entity will serve to translate the many-to-many relationship into two separate many-to-one relationships, facilitating the connection between the source entity (suppliers) and the target entity (retail stores). This approach ensures that the data model accurately captures the complex relationships between entities, and it aligns with standard practices for managing many-to-many relationships in database systems including Microsoft Dynamics 365 Customer Insights.
D is correct, per Microsoft Learn: Many-to-many relationships can be created using two many-to-one relationships and a linking table, which connects the source table and the target table. https://learn.microsoft.com/en-us/dynamics365/customer-insights/data/relationships