Practice Free MB-820 Exam Online Questions
HOTSPOT
You need to write an Upgrade codeunit and use the DataTransfer object to handle the data upgrade.
Which solution should you use for each requirement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Explanation:
Upgrade codeunit trigger: OnValidateUpgradePerDatabase
Since the question specifies that you are handling data upgrades, and you need to use validation before upgrading at the database level, the correct choice is OnValidateUpgradePerDatabase. This method ensures that the upgrade process is validated before applying to the entire database, making it more efficient when data affects multiple companies or structures. DataTransfer method to use: CopyRows
CopyRows is the appropriate method when you are handling large data transfers between tables, especially in an upgrade scenario where you are migrating or transferring data from one table to another. It copies entire rows of data and is optimal for bulk data operations during upgrades.
DRAG DROP
A company has the following custom permission set:
You need to make the permission set visible on the Permission Sets page.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Explanation:
To make the permission set visible on the Permission Sets page, perform the following actions in sequence:
Change the Assignable property value to true.
Add the ObsoleteState = No property.
Publish the app with the permission set to an environment.
Process for making permission sets visible:
In Business Central, the Assignable property determines whether a permission set is shown in the user interface for assigning to users. By default, if Assignable is set to false, the permission set is hidden. Therefore, it should be set to true to make the permission set visible.
The ObsoleteState property indicates whether an object is outdated (Obsolete) or not (No). If an object is marked as obsolete, it is typically hidden from the user interface. Therefore, setting ObsoleteState = No ensures that the permission set is not treated as outdated and remains visible. Finally, publishing the app with the permission set to an environment updates the environment with the new or modified objects, including permission sets, making them available for assignment to users.
You are exporting data from Business Central.
You must export the data in a non-fixed length and width in CSV format.
You need to generate an XMLport to export the data in the required format
Which Format property value should you use?
- A . XML
- B . VariableText
- C . FixedText
B
Explanation:
When exporting data from Business Central and the requirement is for the data to be in a non-fixed length and width CSV format, the Format property of the XMLport should be set to VariableText (B). The VariableText format is designed for handling data exports where the fields are separated by a delimiter, such as a comma or tab, which is typical of CSV (Comma-Separated Values) files. This format allows for the flexibility needed when dealing with varying field lengths, as it does not enforce a fixed width for each field, making it ideal for CSV data exports. Setting the Format property to FixedText (C) would enforce a fixed width for each field, which is not suitable for CSV files, while the XML format (A) is used for exporting data in an XML structure, which is different from the CSV format requirements.
HOTSPOT
You create a table with fields.
You observe errors in the code
You need to resolve the errors.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Explanation:
In line 12, declare "Job Task" as a variable. = NO
Add the property FieldClass = FlowField; for field 3. = YES
Add the property FieldClass = FlowFilter; for field 3. = NO
In line 23, assign the "User Setup" table to a field. = YES
For "In line 12, declare ‘Job Task’ as a variable": In the AL code provided, the "Job Task" appears to be part of a CalcFormula of a FlowField, which means it references a table and not a variable. The "Job Task" does not need to be declared as a variable because it is used to reference a table in a CalcFormula expression.
For "Add the property FieldClass = FlowField; for field 3": The line of code CalcFormula = sum("Job Task"."Recognized Sales Amount" where("Job No." = field("No."))); indicates that this field is calculated from other table data, which is the definition of a FlowField. Therefore, adding the property FieldClass = FlowField; is necessary for the field to function correctly.
For "Add the property FieldClass = FlowFilter; for field 3": FlowFilters are used to filter data based on
the value in a flow field. Since field 3 is using a CalcFormula to sum values, it is a FlowField and not a FlowFilter. Therefore, this statement is not correct.
For "In line 23, assign the ‘User Setup’ table to a field": The line TableRelation = "User Setup"; suggests that the "Project Manager" field has a relation to the "User Setup" table, which is a method of assigning a table to a field to ensure that the values in "Project Manager" correspond to values in the "User Setup" table. Hence, this statement is true.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result these questions will not appear in the review screen.
A company plans to optimize its permission sets.
The company has the following permission sets:
You need to provide the following implementation for a third permission set:
• Create a new Permission Set C that is a composite of Permission Set A and Permission Set B.
• Assign Permission Set C to a user.
You need to ensure that the user has only read access to the Job table.
Solution: Set the IncludedPermissionSets property to Permission Set A and the Excluded PermissionSets property to Permission SetB.
Does the solution meet the goal?
- A . Yes
- B . No
HOTSPOT
A company uses Business Central. The company has branches in different cities.
A worker reports that each time they generate a daily summary report they get an error message that they do not have permissions.
You need to resolve the issue.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
HOTSPOT
You need to define the properties of the comments field of the Non-conformity page.
How should you complete the code segment? To answer, select the appropriate options in the answer area. NOTE; Each correct selection is worth one point.
HOTSPOT
You are writing a procedure to block all inventory items with numbers that do not start with the letter S.
You need to complete the procedure.
How should you complete the code expressions? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Explanation:
procedure BlockNonSItems()
var
Item: Record Item;
begin
// Reset the Item record to clear any previous filters. Item.Reset();
// Set the filter to exclude items that start with ‘S’. Item.SetFilter("No.", ‘<>%1*’, ‘S’);
// Find each item that matches the filter.
if Item.FindSet() then
repeat
// Set the Blocked field to true to block the item. Item.Blocked := true;
// Save the changes to the Item record. Item.Modify();
until Item.Next() = 0; // Continue until no more items are found.
end;
You need to add a property to the Description and Comments fields with corresponding values for the control department manager.
Which property should you add?
- A . Description
- B . Caption
- C . ToolTip
- D . InstructionalText
HOTSPOT
You need to create the code related to the Subcontract Documents table to meet the requirement for the quality department.
How should you complete the code segment? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
