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…
Question
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)- A7% (4)
- B6% (3)
- C72% (39)
- D15% (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
Community Discussion
No community discussion yet for this question.