Question 1 of 30
In a Power Platform application, you are tasked with designing a data model that includes a one-to-many relationship between a \"Customer\" entity and an \"Order\" entity. Each customer can have multiple orders, but each order is associated with only one customer. If you want to ensure that the data integrity is maintained and that every order must be linked to a customer, which of the following approaches would best achieve this requirement while also allowing for efficient querying of orders by customer?
Implement a foreign key in the "Order" entity that references the "Customer" entity's primary key.
Create a separate entity for "Customer Orders" that links customers and orders without direct relationships.
Use a many-to-many relationship between customers and orders to allow flexibility in data association.
Store customer information directly within the "Order" entity to eliminate the need for relationships.

Preparing for Microsoft PL-400 Microsoft Power Platform Developer? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free