Microsoft Power Platform Solution Architect — Question 85

A company uses Microsoft Power Platform. The company has a database that has two tables: Department and Employee.

The company plans to define a data model to meet the following requirements:

• Each row in the Department table can be linked to more than one row in the Employee table.
• Each row in the Employee table can be linked to only one row in the Department table.
• Action taken on one table will not affect the other table.

You need to define the relationship between the tables.

Which relationship type should you use?

Answer options

• A. many-to-many relationship and parental relationship behavior
• B. many-to-many relationship and custom relationship behavior
• C. many-to-one relationship and Referential, Remove Link
• D. many-to-one relationship and Referential, Restrict Delete

Correct answer: C

Explanation

The correct answer is C, as a many-to-one relationship allows multiple Employees to be linked to a single Department, fulfilling the requirement that each Employee can only relate to one Department. Options A and B, which propose many-to-many relationships, do not align with the stated condition of Employees being linked to only one Department. Option D, while a valid many-to-one option, does not meet the requirement that actions on one table do not affect the other.