Question 12 of 103 from exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer

Prev Question Next Question

Question

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?

Answers

A. None

B. Cascade

C. Cascade + Restricted

D. Restricted.

Show Answer

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

Example of Restricted - Suppose we have two tables(Customer &amp; Order) and the relation is of One-To-Many i.e Customer can have many orders.

So on a parent table i.e.(Customer) if I set a delete action property to RESTRICTED for Order table.

Then If I go and delete the record from a Customer table.

It will first check the record in the child table and if exist that warning prompt saying that first we need to delete a record from child table.

Incorrect Answers: B: Example of Cascade: Suppose we have two tables(Customer &amp; Order) and the relation is of One-To-Many i.e.

Customer can have many orders.

So on a parent table i.e.(Customer) if I set a delete action property to CASCADE for Order table.

Then If I go and delete the record from a Customer table.

It will also delete all the related records in Order table automatically.

C: Example of Cascade + Restricted Suppose we have three tables(Person ,Customer &amp; Order) Now Person is a parent of Customer table, and Customer is a parent of Order table having (One-To- Many) relations - If I set a Delete action property on Person table to CASCADE for customer tableand If I set aDelete Action property on a CUSTOMER table for Order table to CASCADE +RESTRICTED.

So if I delete a record from Customer table then It will first check the record in the child table(order table) and if exist that warning prompt saying that first we need to delete a record from child table.

But if I delete a record from Person table it will automatically delete a record in Customer table and all records related to customer table in Order table would also be deleted.

https://amazingax.wordpress.com/2013/01/13/microsoft-dynamics-ax-2012example-of-cascaderestricted-and-cascade-restricted-delete-action-property-for-a-

Prev Question Next Question