Microsoft Microsoft Certifications MB-820 Questions & Answers

• Question 31:

  HOTSPOT

  You develop a test application.

  You must meet the following requirements:

  1.

  Roll back changes to a test method after run time.

  2.

  Run an approve action on a test page named TestPageA.

  You need to implement the given requirements on the test codeunit

  Which actions should you perform? To answer, select the appropriate options in the answer area

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  To roll back changes to a test method after run time, you should:

  Set the TransactionModel attribute to AutoRollback. To run an approve action on a test page named TestPageA, you should:

  Configure TestPageA.Approve.Invoke().

  In Business Central's testing framework, the TransactionModel attribute can be set to AutoRollback. This ensures that any changes made during the test are rolled back after the test is complete, leaving the database in its original state. For

  running an action on a test page, you would use the 'Invoke' method on the action you wish to perform. In this case, to run an approve action on TestPageA, you would use TestPageA.Approve.Invoke() within your test codeunit. This simulates

  the user action of approving something on the page.

  These actions ensure that the testing environment is properly set up to test specific functionalities without persisting test data and to invoke actions as part of the test scenarios.

• Question 32:

  HOTSPOT

  You create an 'AddltemsToJson" procedure and publish it.

  

  The procedure fails to run.

  You need to fix the errors in the code.

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  Hot Area:

  

  Correct Answer:

  

  In line 13, replace the Add method with Insert. = NO In line 15, replace the WriteTo method with ReadFrom. = NO Change the ItemObject variable type from JsonObject to JsonToken. = NO Move line 08 in the beginning of REPEAT .. UNTIL.

  = YES The provided code is intended to serialize a list of items from the Item table into a JSON array format. Here is a breakdown of the code and the necessary corrections:

  In line 13, "ItemsArray.Add(ItemObject)": This line is correctly using the Add method to add the ItemObject to the ItemsArray. The Add method is the correct method to use for adding items to a JsonArray. Therefore, there is no need to replace

  Add with Insert.

  In line 15, "ItemsArray.WriteTo(RequestText)": The WriteTo method is used correctly to serialize the ItemsArray into a JSON formatted string and store it in the RequestText variable. The ReadFrom method is used for the opposite operation,

  i.e., to deserialize a JSON formatted string into a JsonArray, which is not the goal in this context. Hence, no change is needed here. Change the ItemObject variable type from JsonObject to JsonToken: The ItemObject variable is intended to

  hold JSON objects representing individual items, making JsonObject the appropriate type. JsonToken is not a type used in this context within AL for Business Central, and thus the variable type should remain as JsonObject.

  Move line 08, "Clear(ItemObject)": This line should be moved inside the repeat loop to ensure that the ItemObject is cleared for each item in the loop. Placing it before the repeat would only clear it once before the loop starts, which could lead

  to incorrect serialization as the previous item's properties would not be cleared from the ItemObject.

  The logic for serializing records into JSON is a common operation when interfacing with APIs or web services in Business Central, and the pattern shown in the code is typical for such operations.

• Question 33:

  HOTSPOT

  A company has a page named New Job Status connected to a source table named Job. The page has an action named Item Ledger Entries. The company requires the following changes to the page:

  1.

  Filter the page to display only jobs with open or quote status.

  2.

  Add the following comment for internal use: This page does not include completed jobs.

  3.

  Item Ledger Entries action must open the selected job on the page and display it in the Ul for users to modify.

  You need to select the property selections to use for each requirement.

  Which property selections should you use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 34:

  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.

  Hot Area:

  

  Correct Answer:

  

  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.

• Question 35:

  HOTSPOT

  A company plans to customize its per tenant extension reports. The company has the following requirements for the customization:

  1.

  Child data items must not be displayed on the request page for some master detail reports.

  2.

  Selecting key filter fields takes users too much time. The customization must decrease the amount of time to select the fields.

  You need to optimize the report request page.

  Which actions should you configure? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  For the given requirements, you should configure the following actions:

  For child data items not to be displayed on the request page for some master- detail reports, set the DataItemLinkReference property to the parent data item. To decrease the amount of time to select key filter fields, specify the

  RequestFilterHeading property.

  In Dynamics 365 Business Central, when customizing report request pages, certain properties can be set to control the behavior and display of the report options:

  Hiding Child Data Items:The DataItemLinkReference property is used to link a child data item to a parent data item in the data model of a report. Setting this property correctly will ensure that the child data items are related to the correct

  parent data item and will be displayed or hidden accordingly on the request page. If the goal is to prevent child data items from being displayed, you need to make sure they are correctly linked and configured to not appear. Optimizing Filter

  Field Selection:The RequestFilterHeading property is used to group filter fields on the request page. By specifying this property, you can create a more organized and user-friendly interface, which can significantly speed up the process of

  selecting filters. This property allows you to categorize filters into headings, making it quicker and easier for users to find and set the necessary filters for the report.

  By adjusting these properties on the report request page as part of the per tenant extension customization, you will address the company's requirements to optimize the user experience when running reports.

• Question 36:

  HOTSPOT

  A company is setting up a custom telemetry trace signal to send traces on failed customer statement emails.

  

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  Hot Area:

  

  Correct Answer:

  

  The telemetry trace sends custom signals to an Application Insights resource specified in the extension's app.json file and on the tenant. = YES Dictionary keys for the extension name and version must be specified to identify the extension

  during analysis. = YES

  The telemetry trace sends events to Application Insights resources set up on the tenant. = YES

  Telemetry in Business Central allows developers to collect custom telemetry for extensions using Application Insights. The telemetry trace is used to send custom signals to an Application Insights resource. This resource is typically specified

  in the app.json file of the extension and must be configured on the tenant where the extension is installed. The use of dictionary keys for the extension name and version is a best practice to identify the extension during analysis in Application

  Insights. These keys can be added to the telemetry trace to ensure that when the data is collected, it's clear which extension the data is associated with.

  Finally, it is correct that the telemetry trace sends events to Application Insights resources that are set up on the tenant, enabling the collection and analysis of telemetry at the tenant level.

• Question 37:

  HOTSPOT

  You create a query that contains a procedure to display the top customers.

  The procedure breaks at runtime.

  

  You need to fix the code.

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Enclose line 08 into BEGIN .. END = NO Add TopCustomerOverview.Open(); before = YES TopCustomerOverview.SetFilter(Sales_LCY, '>10000'); in line 06. Add TopCustomerOverview.Open(); after TopCustomerOverview.SetFilter(Sales_LCY, '>10000'); in line 06. = YES Replace SetFilter in line 06 with SetRange. = NO

  The code provided has a runtime error because the query TopCustomerOverview must be opened before it can be read from. Therefore, TopCustomerOverview.Open(); should be added before trying to read from the query, which is not present in the code. Enclosing line 08 into a BEGIN .. END block is unnecessary because it is a single statement, and AL does not require a BEGIN .. END block for single statements within trigger or procedure bodies. TopCustomerOverview.SetFilter(Sales_LCY, '>10000'); is a correct method to set a filter for the query, and using SetRange instead is not necessary unless the requirement is specifically to set a range of values, which is not indicated in the procedure's description. In summary, for the procedure to run correctly, the query must be opened after setting the filter and before attempting to read from it. The SetFilter method is correct for the intended operation, and there's no requirement to use SetRange or to enclose the Message call in a BEGIN .. END block.

• Question 38:

  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.

  Hot Area:

  

  Correct Answer:

  

  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;

• Question 39:

  HOTSPOT

  You need to create the API page according to the requirements.

  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.

  Hot Area:

  

  Correct Answer:

  

  Box 1: DataAccessIntent = readOnly;

  Scenario:

  Contoso, Ltd. must create an API in Business Central to expose item details to the mobile application.

  The API must have the lowest possible impact on the production environment when used during working hours.

  The API must only support Get operations.

  DataAccessIntent Property

  Sets the data access intent of the page.

  Applies to

  Page

  Report

  Query

  Property Value

  *

  ReadOnly

  Intent to access records, but not to modify them. Read-only pages are run against a replica of the database leading to improved performance, but preventing modifications to the database records.

  *

  ReadWrite

  Intent to access and modify records.

  Syntax

  DataAccessIntent = ReadOnly|ReadWrite;

  Remarks

  For reports, API pages, and API queries, the Business Central server can use read-only database replicas on Azure SQL Database and SQL Server. If replicas are enabled, use this property to reduce the load on the primary database. Using

  ReadOnly might also improve performance when viewing objects. ReadOnly works as a hint for the server to route the connection to a secondary (read-only) replica, if one is available. When a workload is executed against the replica, insert/

  delete/modify operations aren't possible. If any of these operations are executed against the replica, an exception is thrown at runtime.

  Box 2: Editable = false;

  Note: It only applies to pages of the type API. For such, The Editable property must be set to false.

  Reference: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-dataaccessintent-property

• Question 40:

  HOTSPOT

  You need to write the code to call the subcontractor's REST API.

  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.

  Hot Area:

  

  Correct Answer:

  

  Box 1: 'Authorization'

  Business Central and the AL language have made web service code much easier with the HttpClient and Json types available. Handling the HTTP Authorization header is easier too with the TempBlob table, which can now encode the basic

  authentication string using base64.

  See below for an example of how to add a basic authorisation header to the AL HttpClient:

  procedure AddHttpBasicAuthHeader(UserName: Text[50]; Password: Text[50], var HttpClient : HttpClient);

  var

  AuthString: Text;

  TypeHelper: "Type Helper";

  begin

  AuthString := STRSUBSTNO('%1:%2, UserName, Password);

  AuthString := TypeHelper.ConvertValueToBase64(AuthString);

  AuthString := STRSUBSTNO('Basic %1', AuthString);

  HttpClient.DefaultRequestHeaders().Add('Authorization', AuthString);

  end;

  Box 2: Base64Convert.ToBase64(Username + ':' + Passsword)

  How To Connect To External APIs From Business Central (HTTP Request)

  Authentication

  There are several methods of authentication, basic, OAuth, etc. In the next example, you can see a way to use basic authentication.

  We introduce 2 new types, HttpRequestMessage and HttpHeaders. They become fundamental when creating more complex API calls.

  The way to build the call is quite simple:

  Set the information for the message

  Set the authorization in the header of the message

  Send the request

  Read and handle the response

  Example:

  Box 3: httpContent.WriteFrom(Body)

  Example

  The following example illustrates how to use the HttpContent type to send a simple POST request containing JSON data.

  // Add the payload to the content content.WriteFrom(payload);

  // Replace the default content type header with a header associated with this request content.GetHeaders(contentHeaders); contentHeaders.Clear(); contentHeaders.Add('Content-Type', 'application/json');

  // Assigning content to request.Content will actually create a copy of the content and assign it.

  // After this line, modifying the content variable or its associated headers will not reflect in

  // the content associated with the request message

  request.Content := content;

  request.SetRequestUri(uri);

  request.Method := 'POST';

  Box 4: httpClient.Post(Url,httpContent,ResponseMessage) POST as required, and include ResponseMessage.

  Scenario: The API for sending subcontracting orders must be called by sending an authenticated POST request to the given endpoint.

  Scenario, full:

  An external business partner of Contoso, Ltd. exposed a REST API for receiving details about new subcontracting orders and for sending the planned release date of each subcontracting order received.

  Integration with business partner for subcontracting

  Contoso, Ltd. must connect Business Central to the external API provided by the business partner. This will be used for the partner to send the details of new subcontracting orders to fulfill the sales demand, and for receiving the planned

  release date of each order sent. The integration requirements are as follows:

  The business partner will provide a REST API secured with basic authentication. Credentials to access the API will be shared with Contoso, Ltd.

  The API for sending subcontracting orders must be called by sending an authenticated POST request to the given endpoint.

  The API for retrieving the order no. and planned release date of each subcontracting order responds with the following JSON:

  Reference:

  https://dankinsella.blog/http-basic-authentication-with-the-al-httpclient/ https://businesscentralgeek.com/how-to-connect-to-external-apis-from-business-central-http-request https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/httpcontent/httpcontent-data-type