Free Microsoft Dynamics MB-820 Actual Exam Questions - Question 9 Discussion

Question No. 9Drag & Drop

DRAG DROP A company is implementing Business Central. In the per-tenant extension, TableA Header and TableA Line are document tables, and TableB Header and TableB Line are document history tables. The company requires that the resulting dataset of query objects contain the following records: • All records from TableA Header even if no matching record value exists in the linked TableA Line • Records from TableB Header where a match is found in the linked TableB Line field You need to configure the linked data item to generate the required dataset. Which SqlJoinType should you use? To answer, move the appropriate SqUoinTypes to the correct dataset requirements. You may use each SqlJoinType once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content. MB-820 practice exam questions

Options
ACrossJoin
BInnerJoin
CLeftOuterJoin
DRightOuterJoin
Drag an item to a target. Click × to remove.
Answer Area
Include all records from TableA Header.
Drop item here
Include only matched records from TableB Header.
Drop item here
US
YQ
Yasir Q.
2026-01-22

Left join for TableA to keep all headers; inner join for TableB to filter.

0