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…

The correct answer is LeftOuterJoin; InnerJoin. You've hit your limit · resets 5:20am (America/New_York)

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

Correct arrangement

  • LeftOuterJoin
  • InnerJoin

Explanation

You've hit your limit · resets 5:20am (America/New_York)

Topics

#query objects#SqlJoinType#OuterJoin#InnerJoin

Community Discussion

No community discussion yet for this question.

Full MB-820 Practice