nerdexam
Microsoft

MB-820 · Question #54

Drag and Drop Question You create the following Vendor table and Item table in Business Central. Vendor: Item: You require the following data set to assign vendors to items. You need to create a query

Sign in or unlock MB-820 to reveal the answer and full explanation for question #54. The question stem and answer options stay visible for context.

Develop by using AL objects

Question

Drag and Drop Question You create the following Vendor table and Item table in Business Central. Vendor: Item: You require the following data set to assign vendors to items. You need to create a query to assign the vendors. Which three code blocks should you use to develop the solution? To answer, move the appropriate code blocks from the list of code blocks to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select. Answer:

Exhibits

MB-820 question #54 exhibit 1
MB-820 question #54 exhibit 2

Answer Area

Drag items

SqlJoinType = LeftOuterJoin;DataItem("Vendor"; Vendor)DataItemLink = "Vendor No." = Vendor."Vendor No.";SqlJoinType = RightOuterJoin;DataItem(Item; Item)SqlJoinType = InnerJoin;DataItemLink = "Vendor No." = Item."Vendor No.";SqlJoinType = CrossJoin;

Unlock MB-820 to see the answer

You've previewed enough free MB-820 questions. Unlock MB-820 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#AL queries#table joins#vendor-item relationship#query objects
Full MB-820 Practice