Correct Answer: B
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 orders. One customer can have multiple orders. The customer record is related to the multiple records in the Orders table from the Customers table point. It is a One-to-Many relationship for a customer record. For the related order record, this relation is Many-to-One. When you create such a relationship between tables, the Dataverse automatically adds a Lookup column in a child or related table. When you relate two tables in the Many-to-One or One-to-Many relationship, you need to instruct the Dataverse what to do when you delete the records from the parent table.
There are three advanced options for relationship behavior: Referential, Parental, and Custom.
The Referential type preserves the child records from the actions on the parent records. It has two options: Remove Link and Restrict.
If you use a Restrict option, you prevent the deletion of the parent records related to child records.
If you use a Remove Link option, you preserve the child records when a parent record is deleted. Therefore, Option B is the correct answer.
Option A is incorrect because the Parental type defines the child records` deletion when you delete the parent record.
Option C is incorrect because Custom Cascade All defines the child records` deletion when you delete the parent record. This behavior is the same as the Parental type.
Option D is incorrect because the Referential Restrict prevents the parent record`s deletion without deletion of any related child records.
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