Microsoft Dynamics 365 Customization and Configuration (legacy) — Question 12

You configure a 1:N relationship between two entities and set the cascade rule for deletion to Referential.
What effect does deleting the parent record have on any child records?

Answer options

• A. The child records remain but the link to the parent record is removed.
• B. The parent record cannot be deleted until all of the child records are first deleted.
• C. The child records are deleted and the link to the parent record shows as deleted.
• D. The child records are deleted along with the parent record.

Correct answer: D

Explanation

When the cascade rule for deletion is set to Referential, deleting the parent record results in the deletion of all associated child records. Option A is incorrect because it suggests the child records remain, which is not true with Referential deletion. Option B is wrong because it implies that the parent must wait for the child records to be deleted, which is not how Referential works. Option C misstates the outcome since it suggests only the link is deleted, not the child records themselves.