Correct Answers: A, B and D
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 person and multiple email addresses. One person can have multiple email addresses. The person record is related to the multiple records in the Email table from the Person table point. It is a One-to-Many relationship for a person record. For the related email 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. For Many-to-One or One-to-Many relationships, you need to instruct the Dataverse what to do when you delete the records from the parent table. This instruction is called a behavior. There are three advanced options for relationship behavior: Referential — this type preserves the child records from the actions on the parent records. It has two options: Remove Link and Restrict. If you use a Remove Link option, you preserve the child records when a parent record is deleted. If you use a Restrict option, you prevent the deletion of the parent records related to child records, and you cannot delete the parent record without deleting all child records first.
Parental — this type defines the child records` deletion when you delete the parent record. It does not prevent the deletion of the parent record when the related records exist.
Custom — this type provides a configuration for each cascade type of action.
Option A is correct because the Parental type defines the child records` deletion when you delete the parent record. It does not prevent the deletion of the parent record when the related records exist.
Option B is correct because Custom Cascade All defines the child records` deletion when you delete the parent record. This behavior is the same as the Parental type. It does not prevent the deletion of the parent record when the related records exist.
Option D is correct because the Referential Remove Link type defines the parent record`s deletion without deleting any related child records. It does not prevent the deletion of the parent record when the related records exist.
Option C is incorrect because the Referential Restrict prevents the parent record`s deletion before deleting the child records. This behavior type does not help you if you want to set the parent record owner to be the owner of the child records. You need to use the Custom Cascade User Owner settings.
For more information about Dataverse table relationship behavior, please visit the below URLs:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships#table-relationship-behavior
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-entity-lookup