Online Access Free MB-820 Exam Questions

You have a decimal variable named AmountlCY.
You need to round up the variable to four decimal places.
Which result value should you use?

• A.Result: = Round {AmountLCY. 0.0001. =');
• B.Result: = Round (AmountLCY. 0.0001. '<'):
• C.Result: = Round (AmountLCY, 0.0001, >');
• D.Result: = Round (AmountLCY,A. '>"}:

You are creating an entitlement object in Business Central to enable transactability for AppSource apps.
You must map the entitlement object to a plan in Partner Center.
You need to select the value of the Type property to use in the entitlement object.
Which value should you use?

• A.PerUserServicePlan
• B.Role
• C.Unlicensed
• D.Implicit

You are developing an XMLport to export data from the parent Item table and a related child "Item Unit of Measure' table. The XMLport configuration must provide the following:
* Link the child table to its parent.
* Display a confirmation message after the XMLport runs.
You need to generate the XMLport.
What should you do? To answer, move the appropriate triggers to the correct requirements. You may use each trigger 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.

Correct Answer:

Explanation:
To meet the XMLport configuration requirements:
* Link the child table to its parent: Use the OnAfterGetRecord trigger.
* Display a confirmation message after the XMLport runs: Use the OnPostXMLPort trigger.
In Business Central, when you are developing an XMLport for data export, triggers are used to perform actions at different stages of the XMLport's operation:
* OnAfterGetRecord Trigger:This trigger fires after a record is retrieved from the database but before it is processed for output in the XMLport. It is the ideal place to link child table records to their parent because you have access to the current record that can be used to set filters or modify data in the child table before it is written to the XML file.
* OnPostXMLPort Trigger:This trigger fires after the XMLport has finished processing all records. It is the correct place to display a confirmation message because it ensures that the message will appear after the entire XMLport operation is complete. Here, you can use application-specific functions to show the message, such as MESSAGE function in AL code.
By placing the appropriate triggers in these positions, you can ensure that the XMLport will link the child records to their parent records during the data export process and will notify the user with a confirmation message once the operation is successfully completed.

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.

Correct Answer:

Explanation:

* Include all records from TableA Header even if no matching record value exists in the linked TableA Line: LeftOuterJoin
* Include only matched records from TableB Header: InnerJoin
In SQL and similarly in Business Central when defining table relationships in query objects, the type of join determines how records from one table are combined with records from another table. Here's what each join type means in the context of the company's requirements:
* LeftOuterJoin:
* A LeftOuterJoin includes all records from the 'left' table (TableA Header) and the matched records from the 'right' table (TableA Line). If there is no match, the result is NULL on the side of the 'right' table. This is why it fits the requirement to include all records from TableA Header even if there is no matching record in TableA Line.
* InnerJoin:
* An InnerJoin includes records when there is at least one match in both tables. So, it will only include records from TableB Header where a corresponding match is found in TableB Line. If there is no match, the records from TableB Header will not appear in the result set. This aligns with the requirement to include only matched records from TableB Header.
By using these join types, the company can ensure that their dataset includes the appropriate records from the document tables and document history tables according to their specified requirements.

A company has an on-premises Business Central instance named TEST The instance uses Windows authorization and a developer services port of 7149 Visual Studio Code is installed on the same server.
You create a new AL project but cannot download the symbols.
The launch json file contains the following code:

You need to download the symbols.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Check which server the instance is installed on and replace http//localhost with the correct IP address.
• B.Change the server Instance parameter to TEST
• C.Change the name parameter to TEST.
• D.Add the port: 7149 parameter.
• E.Change the authentication parameter to UserPassword.