Exam MB-500 topic 1 question 12 discussion

Actual exam question from Microsoft's MB-500

Question #: 12
Topic #: 1

You are a Dynamics 365 Finance developer. You have two tables as shown in the following exhibit:

You need to configure Table1 to ensure that records cannot be deleted from Table1 if Table2 contains related records.
Which value should you use for the OnDelete property?

A. None
B. Cascade
C. Cascade + Restricted
D. Restricted

Show Suggested Answer

Suggested Answer: D 🗳️

by jhramirez at Jan. 15, 2021, 8:53 p.m.

Comments

Submit Cancel

globeearth

2 months, 4 weeks ago

Selected Answer: D

Scenario: A user or process attempts to directly delete a record in Table1 without it being part of a higher-level cascading deletion. Behavior: The system checks if there are any related records in Table2 that reference the Table1 record being deleted (via the foreign key relationship, e.g., Table1Id in Table2). => If related records exist in Table2, the deletion of the Table1 record is blocked, and an error is thrown (e.g., “Cannot delete a record in Table1. The corresponding record is used in Table2”). => If no related records exist in Table2, the Table1 record is deleted.

upvoted 1 times

...