nerdexam
Microsoft

PL-600 · Question #257

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…

The correct answer is C. many-to-one relationship and Referential, Remove Link. This is a one-to-many/many-to-one relationship. In a many-to-one relationship with Referential and Remove Link, multiple records in one table (the "many" side) can be linked to a single record in another table (the "one" side). If the record in the "one" side is deleted, the…

Submitted by rachelw· Apr 18, 2026Architect a solution

Question

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?

Options

  • Amany-to-many relationship and parental relationship behavior
  • Bmany-to-many relationship and custom relationship behavior
  • Cmany-to-one relationship and Referential, Remove Link
  • Dmany-to-one relationship and Referential, Restrict Delete

How the community answered

(54 responses)
  • A
    7% (4)
  • B
    6% (3)
  • C
    72% (39)
  • D
    15% (8)

Explanation

This is a one-to-many/many-to-one relationship. In a many-to-one relationship with Referential and Remove Link, multiple records in one table (the "many" side) can be linked to a single record in another table (the "one" side). If the record in the "one" side is deleted, the links to it in the "many" side are simply removed, but the records in the "many" side remain in the database. Referential, Remove Link: In a referential relationship between two tables, you can navigate to any related rows, but actions taken on one won't affect the other. For example, if you have a one- to-many relationship between teachers and classes, deleting a teacher will have no impact on the https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-entity-lookup

Topics

#Data Modeling#Relationships#Dataverse#Relationship Behavior

Community Discussion

No community discussion yet for this question.

Full PL-600 Practice