<< Prev Question Next Question >>

Question 23/26

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.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (26q)
Question 1: You need to select the appropriate page types to solve the r...
Question 2: You are developing an app that will be published to Microsof...
Question 3: You create a Business Central report. You need to insert val...
Question 4: You are developing an XMLport to export data from the parent...
Question 5: You need to determine why the extension does not appear in t...
Question 6: You need to create the API page according to the requirement...
Question 7: You create a Business Central report. You need to insert val...
Question 8: You need to handle the removal of the Description field and ...
Question 9: A company plans to meet new regulatory requirements. The reg...
Question 10: You need to write the code to call the subcontractor's REST ...
Question 11: You create a page with the PageType property set to RoleCent...
Question 12: You need to determine If you have unwanted incoming web serv...
Question 13: You plan to write unit test functions to test newly develope...
Question 14: A company uses Business Central. The company has branches in...
Question 15: You are exporting data from Business Central. You must expor...
Question 16: You have a decimal variable named AmountlCY. You need to rou...
Question 17: You are developing an app. You plan to publish the app to Mi...
Question 18: You create the following Vendor table and Item table in Busi...
Question 19: You create a table with fields. You observe errors in the co...
Question 20: A company owns and operates hotels, restaurants, and stores....
Question 21: You need to define the data types for the fields of the N on...
Question 22: A company has a task that is performed infrequently. Users o...
Question 23: A company is implementing Business Central. In the per-tenan...
Question 24: A company plans to customize its per tenant extension report...
Question 25: Note: This question is part of a series of questions that pr...
Question 26: A company is setting up a custom telemetry trace signal to s...