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)
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
Answer Area
Drag items
Correct arrangement
- LeftOuterJoin
- InnerJoin
Explanation
You've hit your limit · resets 5:20am (America/New_York)
Topics
Community Discussion
No community discussion yet for this question.
