nerdexam
Microsoft

MB-820 · Question #53

Drag and Drop Question 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 histor

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

Develop by using AL objects

Question

Drag and Drop Question 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 SqlJoinTypes 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. NOTE: Each correct selection is worth one point. Answer:

Exhibit

MB-820 question #53 exhibit

Answer Area

Drag items

CrossJoinInnerJoinLeftOuterJoinRightOuterJoin

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

#query objects#SqlJoinType#OuterJoin#InnerJoin
Full MB-820 Practice