ExamGecko
Search Search Login
Home Home / Microsoft / MB-500
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

HOTSPOT You need to implement the integration for the Vendor Exclusion List form. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You are using the SysTest framework to test code in Visual Studio. You need to create a unit test class. Which three attributes can you use to create the class? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
You need to add new fields to the table for the Inventory Status form to represent the product name and batch ID. What are two possible ways to achieve this goal? Each correct answer presents a complete solution. NOTE Each correct selection is worth one point.
You need to implement the payroll application data process. Which two objects should you create? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
HOTSPOT You are the Dynamics 365 Finance Developer. You have the following class definition: You need to create an extension class and wrap the method by using Chain of Command (CoC), if the value of the Qty variable is less than 5, the code must cause an exception. How should you complete the code segment? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT You have the following code: For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
You need to configure security for the Vendor Exclusion List report. What are two possible ways to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
DRAG DROP You need to create the outstanding invoice report for the CFO. Which attributes should you use? To answer, drag the appropriate attributes to the requirements. Each attribute answer may be used once, more than once, or not at all. You may need to drag the split between panes or scroll to view content. NOTE: Each correct selection is worth one point.
You are a Dynamics 365 Supply Chain Management developer. You are working on a project by using Visual Studio. Several users check out a custom form version control and modify the form. You need to find the user that has added a specific line of code to the form. What should you do?
A company uses Dynamics 365 for its supply chain operations. A client wants to ensure current processes do not break when the client receives Microsoft updates for Dynamics 365 finance and operations apps. The company has no development capabilities. You need to build the scenarios to automate the process by using the Regression suite automation tool (RSAT). Which file type should you include to run the scenarios?

Question 150 - MB-500 discussion

Report
Export

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

Answers
A.

None

B.

Cascade

Answers
B.

Cascade

C.

Cascade + Restricted

Answers
C.

Cascade + Restricted

D.

Restricted

Answers
D.

Restricted

Suggested answer: D

Explanation:

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.

Reference:

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

Show Answer
asked 05/10/2024
Robert Fox
50 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms