Equipment World is a small distributor of food processing equipment. Equipment World uses Excel spreadsheets to store information about customers, suppliers, and orders. The Orders table contains information about customer orders and the company`s employees handling the order. The company wants to move from Excel to Power Platform solution and migrate data to the Dataverse. Equipment World asks you to help them with the data model design. 
What type of relationships will you design between the orders and customers and between suppliers and employees who process the orders?

Answer options:

A.One-to-One (1:1) and Many-to-One (N:1)
B.Many-to-One (N:1) and One-to-Many (1:N)
C.One-to-Many (1:N) and Many-to-One (N:1)
D.Many-to-One (N:1) and One-to-One (1:1)
E.Many-to-One (N:1) and Many-to-Many (N:N)
F.Many-to-Many (N:N) and Many-to-One (N:1)

Correct Answer: E 
As a Solution Architect, you need to understand the business processes and how these processes are reflected in a data model. The first step is to evaluate the use of out-of-the-box Dataverse tables and relationships for the company’s business processes and needs. If the out-of-the-box data solutions are not enough, you can create custom tables and relationships. 
Dataverse defines the two types of relationships between tables: One-to-Many (1:N) and Many-to-Many (N:N).
A One-to-Many relationship is a Parent-Child relationship, like between a customer and multiple orders. One customer can have several equipment orders. The customer record in a Customers table will be related to the many records in the Orders table. It is a One-to-Many relationship for a customer record. For the related order record, this relation is Many-to-One (N:1). 
A Many-to-Many relationship is when multiple records from one table relate to the multiple records in another table and vice versa, like a relationship between suppliers and Equipment World employees that process the orders. Each employee can process the equipment from multiple suppliers. Each supplier works with multiple people who process their equipment. The person record in an Employees table will be related to the multiple records in the Suppliers table. And a supplier record in the Suppliers table will be related to the multiple records in an Employees table. It is a Many-to-Many relationship for a person and a supplier records. When users create a Many-to-Many relationship, the Dataverse creates a specific hidden intersect matching table between the two tables` records. 
All other options are incorrect. 
For more information about the Dataverse types of table relationship, please visit the below URLs: 

https://docs.microsoft.com/en-us/learn/modules/data-modeling/5-dataverse
https://docs.microsoft.com/en-us/powerapps/guidance/planning/data-modeling
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-entity-lookup
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships