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
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

