New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam MB-500 Topic 3 Question 15 Discussion

Actual exam question for Microsoft's MB-500 exam
Question #: 15
Topic #: 3
[All MB-500 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: D

Example of Restricted

Suppose we have two tables (Customer & 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 & 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 & 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 table and If I set a Delete 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-table-relation/

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel