Free Microsoft Dynamics MB-820 Actual Exam Questions - Question 10 Discussion
DRAG DROP You create the following Vendor table and Item table in Business Central. 
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. 
I’d go with block A first to set up the tables, since you need to define your data sources upfront. Then block C fits next because it handles the join condition between Vendor and Item, linking them on the right fields. Finally, block D makes sense to pick the output columns you want in the result. The others feel out of place or redundant in this flow. This order covers declaration, joining, and selecting cleanly without mixing logic steps.
I agree that starting with block A makes sense to declare the tables. Another way to look at it is to focus on how the join is constructed; block C seems to set up the join properly between Vendor and Item based on matching fields. Lastly, block D looks like it’s where you pick what you want to output, so putting it last fits. Blocks that filter before declaring tables would cause errors or wouldn’t run logically, so skipping those early on is good. This sequence ensures the query builds up from table definition to join to output selection correctly.
I think the key is to start by defining the data items you need, so using the block that declares the source tables (probably block A). Then, you want to join those tables based on Vendor No. and Item No., which matches with block C. Finally, you'd select the appropriate fields for output, which would be block D. This order makes sense because you first get the tables, join them properly, and then pick the data you want. Blocks that try to set filters before defining tables might not work here, so I'd rule those out.
Missing key details in the explanation, can someone clarify?