Microsoft
MB-500 · Question #158
A company uses Dynamics 365 Finance. You have two tables as shown: When an employee is deleted from EmplTable, the corresponding bank account information must automatically be deleted from…
The correct answer is B. Select the foreign key relation properties from EmplBankAccount. D. Set the value of the OnDelete property to Cascade. Select the foreign key relation properties from the Child Table EmplBankAccount. In the On Delete property we chose Delete Action Type (In our case Cascade). https://14-dynamics365.com/2020/12/21/deleted-actions-ondelete-with-example-microsoft- dynamics-365-fo/
Design and develop AOT elements
Question
A company uses Dynamics 365 Finance. You have two tables as shown: When an employee is deleted from EmplTable, the corresponding bank account information must automatically be deleted from EmplBankAccount You need to ensure that the requirement is met. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Exhibit
Options
- ASet the value of the OnDelete property to Restricted.
- BSelect the foreign key relation properties from EmplBankAccount.
- CSelect the foreign key relation properties from EmplTable.
- DSet the value of the OnDelete property to Cascade.
How the community answered
(35 responses)- A9% (3)
- B74% (26)
- C17% (6)
Explanation
Select the foreign key relation properties from the Child Table EmplBankAccount. In the On Delete property we chose Delete Action Type (In our case Cascade). https://14-dynamics365.com/2020/12/21/deleted-actions-ondelete-with-example-microsoft- dynamics-365-fo/
Topics
#table relations#foreign key#OnDelete Cascade#AOT table design
Community Discussion
No community discussion yet for this question.