Exam MB-820 topic 1 question 36 discussion

Actual exam question from Microsoft's MB-820

Question #: 36
Topic #: 1

DRAG DROP -
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.

Show Suggested Answer

Suggested Answer:

by VPin at April 14, 2024, 11:02 p.m.

Comments

Submit Cancel

R3freshy

Highly Voted 10 months, 1 week ago

In my opinion, if you look at the requirement result, it is sorted by Vendor No. first, and then Item No. if you want to arrange the result as requirement without using any property, the answer is dataitem(Vendor; Vendor) { column("Vendor No."; Vendor."Vendor No.") {} column("Vendor Name"; Vendor."Vendor Name") {} dataItem(Item;Item) { DataItemLink = "Vendor No." = Vendor."Vendor No."; SQLJoinType = InnerJoin; column("Item No."; Item."Item No.") {} column("Item Description"; Item."Item Description") {} } } noted ** if using data Item "Item" before "Vendor", you need to clarify orderBy property = Vendor No. and Item No.

upvoted 7 times

R3freshy

10 months, 1 week ago

So, my answer is 1 dataitem(Vendor; Vendor) 2 dataItem(Item;Item) 3 DataItemLink = "Vendor No." = Vendor."Vendor No.";

upvoted 6 times

...

leoizgon

Most Recent 3 months, 2 weeks ago

dataitem(Vendor; Vendor){} dataitem(Item; Item){} SqlJoinType = InnerJoin;

upvoted 1 times

...

e3b13ec

8 months, 1 week ago

Correct answer is 1 dataitem(Vendor; Vendor) 2 dataItem(Item;Item) 3 DataItemLink = "Vendor No." = Vendor."Vendor No.";

upvoted 4 times

e3b13ec

8 months ago

Considering the exact Result Dataset, and that the question is regarding assigning the Vendors correct answer would be dataitem(Vendor; Vendor) DataItemLink = "Vendor No." = Item."Vendor No."; SQLJoinType = InnerJoin;

upvoted 3 times

...

75ed3a2

1 year, 1 month ago

dataItem(Item;Item) { column("Item No."; Item."Item No.") {} column("Item Des"; Item."Item Des") {} column("Vendor No."; Item."Vendor No.") {} dataItem(Vendor;Vendor) { } }

upvoted 2 times

75ed3a2

1 year, 1 month ago

Continue... dataItem(Vendor;Vendor) { DataItemLink = "Vendor No." = Item."Vendor No."; SQLJoinType = InnerJoin; }

upvoted 4 times

...

VPin

1 year, 2 months ago

The below example is a query that does what is requested, any code block of this exercise belong in this example. query 50000 "Items and Vendors" { DataItem(Item; "Item") { Column(ItemNumber; "No.") { } Column(Description; Description) { } Column(VendorNo; "Vendor No.") { } // Left Outer Join with the Vendor table, you want to show all item values, but show vendor name where vendor no. is available. DataItem(Vendor; "Vendor") { DataItemLink = "No." = Item."Vendor No."; SQLJoinType = LeftOuterJoin; Column(VendorName; Name) { } } } }

upvoted 1 times

...