Microsoft

MB-820 Free Practice Questions — Page 4

Question 33

DRAG DROP - You are developing a test application to test the posting process of a sales order. You must provide the following implementation: Specify the value of post options (dialog: Ship. Invoice, Ship & Invoice) as Invoice. Perform calculations and values checking. You need to complete the development of the test codeunit. Which methods should you use? To answer, move the appropriate methods to the correct implementation. You may use each method 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.

Illustration for MB-820 question 33
Show Answer
Correct Answer: Specify the value of the post options as Invoice: Handler Perform calculations and values checking: Test
Explanation:
Handler methods simulate user interaction and set request page or dialog options such as posting choices. Test methods execute the test logic itself, including calculations, validations, and assertions.

Question 34

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. NOTE: Each correct selection is worth one point.

Illustration for MB-820 question 34 Illustration for MB-820 question 34
Show Answer
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
Explanation:
JsonArray.Add(JsonObject) is valid, and WriteTo is the correct method to serialize JSON to text. JsonObject is the correct type for adding name/value pairs. The issue is that ItemObject must be cleared for each iteration, so Clear(ItemObject) should be moved inside the REPEAT loop before adding properties.

Question 35

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.
B.
C.
D.
Show Answer
Correct Answer: D
Explanation:
In AL (Business Central), rounding *up* to a specific number of decimal places is done with the ROUND method using a precision of 0.0001 for four decimals and the direction parameter '>' to force rounding upward. Therefore the correct result expression is ROUND(AmountLCY, 0.0001, '>'), which corresponds to option D.

Question 36

HOTSPOT - Case study - This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study - To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Company Background - Alpine Ski House is a company that owns and operates hotels, restaurants, and stores. Currently, the company uses the following software and interface: Property management software (PMS) to manage hotel rooms On-premises accounting software to generate sales invoices and create purchase orders An API that allows restaurants and stores to obtain necessary information Restaurants and stores use standalone software for point of sale (POS) devices. Each day, the POS terminals generate a text file of sales data and save the files in a server folder. An account assistant must manually import the files to the current software tables to be processed by the system. The general manager receives several reports monthly from department managers. The reports take too much time to prepare. Planned improvements - The company is moving from a different system to Business Central online to manage the whole company. The company plans to increase efficiency in every department by using APIs to obtain or share information between the different systems. Each department involved in purchasing must be able to make purchase requests automatically and easily. The departments do not need access to the full ERP management system. Technical specifications - Alpine Ski House requires the development of several extensions for the planned improvements. Business Central design patterns must be used to develop all extensions. Alpine Ski House must develop the following pages: Pages that provide multiple configurations in a multistep dialog, like a wizard, to provide required information when the extensions are first installed Department-specific Role Center pages to show relevant information and pages with additional information The IT department plans to use Power BI to analyze departmental information. The database must be configured to provide optimal performance. Department-specific requirements. Housekeeping department The housekeeping department requires the following to increase efficiency and help avoid data entry errors: A Housekeeping Role Center to minimize navigation to relevant areas in Business Central online and to show relevant information in it Pages to embed into a new Room page to show additional information about the Room entity A table named Room Incident for the housekeeping team to enter room issue information A Housekeeping canvas app that connects to an extension The department requires the development of an extension with a new API page named RoomsAPI. The housekeeping team will use RoomsAPI to publish room details, update when work is complete, or provide repair notifications from the canvas app. This custom API page must expose a custom table named Rooms and have an ID 50000. The table must be able to update from the PMS. The PMS team must know the endpoint to connect to the custom API. A developer provides the following details for the API page: The extension must be published in Business Central online and include a list page named Room List that includes all hotel rooms. Installation or updates to this extension must meet the following requirements: Some web services must be published automatically. The version of the specified application's metadata must be obtained in AL language, The code required to perform tasks cannot be accessible from other parts of the application. The Room Incident table information must include the following fields: Incident entry: An incremental number Room No.: A room from the Room table Incident Date: The work date - The table definition in the Room Incident table must autofill the Incident Date when the housekeeping team inserts a new record, The value for Incident Date must be the work date configured in the Business Central online client. Status: Includes the following options to identify the status of the incident: Open: When the Room Incident is created In Progress: When someone starts repair work Closed: When the incident is solved Incident Closing Date: Auto-updating field (when the status passes to Closed, the field will update with the work date) Incident Description: Text - Image: Media data type - The stored picture must be downloadable from a menu action, A Room Incident page must be developed to contain the download action. Department-specific requirements. Restaurants and stores To increase efficiency, the new system must manage the generated data from the restaurants and stores directly by using the API on the POS terminals. The company requires a codeunit called from a job queue to read the information from the POS terminal APIs. The POS terminal information must be stored in a table named POS Information, have an ID 50100, and be editable on a page. The account manager requires an option on the menu of the page to run the process manually. To analyze the information received from the POS terminals, the company requires: A custom API named ticketAPI to export the information to Power BI Use of the Read Scale-Out feature to improve database performance Department-specific requirements. Purchasing department and non-conformity handling The purchasing department requires a new entity in Business Central online to log non-conformities of goods received from vendors. The entity must be set up as follows: The non-conformity entity must have two tables: a header with common information one or more lines with the detailed received items that are non-conforming The entity requires a page named Non-conformity and a subpage named Non-conformity Lines to store the information. When a purchase order with incorrect quantity or quality issues is received, the entity must create a non-conformity document in the system. The following information must be included in the document: Non-conformity Number: must use the No. Series table from Business Central online to manage this field and use these features: Alphanumeric values - Number format that includes “NC” and the year as part of the number; for example, NC24-001 Non-conformity Date: stores only the creation date Vendor No.: stores the number of the vendor that sent the items; only vendors from the company must be included Owner: code of an employee defined in the company Receipt No.: must meet the following conditions: Be an existing receipt No. Be received from the vendor indicated in the Vendor No. field Comments: can include comments with rich text and pictures to illustrate quality problems Status: includes non-conformity statuses, such as: Open - Notified - Closed - Lines must contain the following details: Item No.: item received (for existing inventory items only) Description: item description - Quantity: non-conforming quantity Non-conformity Type: Quality - Quantity - Delivery date - The serial numbers of the non-conformities and the period in which they can be created must be in a configuration table and its corresponding page to allow them to be modified for the users. 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.

Illustration for MB-820 question 36 Illustration for MB-820 question 36
Show Answer
Correct Answer: MultiLine = true; ExtendedDataType = RichContent;
Explanation:
The comments field must support rich text with images and formatting. Setting MultiLine = true enables the rich text editor, and ExtendedDataType = RichContent allows storage of formatted text, pictures, and other rich content as required.

Question 37

DRAG DROP - Case study - This is a case study. Case studies are not timed separately from other exam sections. You can use as much exam time as you would like to complete each case study. However, there might be additional case studies or other exam sections. Manage your time to ensure that you can complete all the exam sections in the time provided. Pay attention to the Exam Progress at the top of the screen so you have sufficient time to complete any exam sections that follow this case study. To answer the case study questions, you will need to reference information that is provided in the case. Case studies and associated questions might contain exhibits or other resources that provide more information about the scenario described in the case. Information provided in an individual question does not apply to the other questions in the case study. A Review Screen will appear at the end of this case study. From the Review Screen, you can review and change your answers before you move to the next exam section. After you leave this case study, you will NOT be able to return to it. To start the case study - To display the first question in this case study, select the "Next" button. To the left of the question, a menu provides links to information such as business requirements, the existing environment, and problem statements. Please read through all this information before answering any questions. When you are ready to answer a question, select the "Question" button to return to the question. Company background and technical environment Current environment - Fabrikam Inc. is a medium-sized company that plans to implement Dynamics 365 Business Central as an ERP system. The company has a development department that will help with the ERP implementation. Most employees work remotely from different countries or regions and speak different languages. The various locations and languages cause issues with the current on-premises software. Planned improvements - Fabrikam Inc. plans to implement new and modern software to manage the company. The company wants to use Business Central because it is cloud-based and meets all company requirements. The company intends to improve reporting and integration functionality by using modern tools such as Power BI and APIs. To reduce the amount of information sent by email, the company plans to expose vendor information to be consumed from external users. Technical specifications - The development department installed Visual Studio Code to create Business Central extensions so the ERP system could be customized according to company needs. All extensions must be developed for the Business Central 2024 wave 1 online version. The development department plans to use telemetry to control the appropriate use of each new development and works directly in licensed sandbox environments supplied by Microsoft. Department-specific requirements The following departments at Fabrikam Inc. have multiple requirements: • Development • Control • Accounting • Quality Development department - The development department designed an extension for the purchase department. Because the developers plan to work with telemetry for monitoring operations, they need the Application Insights information. To accomplish this, the department must add a setting in the corresponding file. The quality department does not want to receive any warning about the Application Insights setting when the extension is compiled. Control department - The control department requires customizations to Business Central by using a per-tenant extension (PTE) named Subcontract Docs. The PTE includes a table named Subcontract Documents. The table has the following fields: ID: A unique identifier - Subcontract No.: Related to the standard Vendors table Description: A short description of a received document Document: A media type that has the document Comments: Comments about the document Date: When the document was imported Amount: Amount related with the imported document Posted: Indicates if the document is managed The extension must be in English - United States (ENU) and Spanish Traditional Sort (ESP) so the application can be used in both languages. The translations must be on the table, not on the page, to avoid repeating them. The control department does not want to use translation files. The control department manager requires a brief guide for the Description and Comments fields when employees create a new record so users know what to include in the fields. The guide must disappear as soon as users add a value in the fields. The Subcontract Documents table must be displayed on a new page named Subcontract Document List through an action from the standard Vendor page. The Amount field, included in the Subcontract Document List, must be formatted in bold format when the record is posted (field Posted = true). The control department also requires a report to display a list of subcontract documents named Subcontract Documents Excel List. The report must meet the following requirements: • Downloads a file only in Microsoft Excel. • Includes a predefined format with two worksheets: one with the posted subcontract documents and another with the unposted subcontract documents. Accounting department - The accounting department plans to use Power BI to analyze information generated by the control department. The accounting department plans to expose an API named API Customer Lines. To improve the performance, the API must use read-only information and work with a Query object to summarize the data. You have the following code: The accounting department must expose data such as the following: The qty column must be the sum of the Outstanding quantity field of Sales Order Lines. It must be in descending order by quantity. The department also exposes a page named Fabrikam Vendor API that includes vendor information from the Vendor table, such as number and name. The API must use the replica database to improve performance. Because Fabrikam Inc. is based in multiple countries and regions, the company periodically must send accounting movements between two dates to the local tax offices named Fabrikam Accounting. The format for this file must be an XML file generated by an XMLport object. For security reasons, it is not possible to receive data from this XMLport. The generated XML file must have a schema like this: Quality department - The quality department requires that every new app or extension is designed to meet standard company guidelines. The quality department plans to follow the standard Business Central data model. The quality development must be able to use triggers correctly. The department must ensure that when a vendor is deleted, the system also removes each record in the Subcontract Documents table related to the vendor. If the subcontract document record has the field Posted = false, it must not be possible to delete the record. The department has a version 1.0.0.1 installed for an extension named Quality Control. The department develops a new version 1.0.0.2 and uses a codeunit with the subtype Upgrade to update it. The department requires the values for AppVersion and DataVersion on the trigger OnUpgradePerCompany after using NavApp.GetCurrentModuleInfo(myinfo). You need to configure the Subcontract Docs extension to translate the fields. 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.

Illustration for MB-820 question 37 Illustration for MB-820 question 37 Illustration for MB-820 question 37 Illustration for MB-820 question 37
Show Answer
Correct Answer: Open the table Subcontract Documents. Add the CaptionML property for each field. Complete the value for CaptionML for each field with the format <ENU>=<English>, <ESP>=<Spanish>.
Explanation:
The requirement forbids translation files and requires translations on the table. This is done by defining CaptionML directly on table fields, so you first open the table, then add CaptionML, and finally fill ENU and ESP values. No app.json features or .xlf generation is needed.

Question 38

HOTSPOT - You are creating a new Business Central report. You plan to use triggers and functions to dynamically create a dataset and control the report behavior. You must provide the following implementation: • Run when the report is loaded. • Run when the data item is iterated for the last time. • Skip the rest of the report. You need to select the triggers and functions for the report. Which triggers and functions should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Illustration for MB-820 question 38
Show Answer
Correct Answer: OnPreReport OnPostDataItem CurrReport.Quit()
Explanation:
OnPreReport runs when the report is loaded and ready to execute. OnPostDataItem fires after the data item has completed its last iteration. CurrReport.Quit() stops execution and skips the rest of the report.

Question 39

HOTSPOT - Case study - This is a case study. Case studies are not timed separately from other exam sections. You can use as much exam time as you would like to complete each case study. However, there might be additional case studies or other exam sections. Manage your time to ensure that you can complete all the exam sections in the time provided. Pay attention to the Exam Progress at the top of the screen so you have sufficient time to complete any exam sections that follow this case study. To answer the case study questions, you will need to reference information that is provided in the case. Case studies and associated questions might contain exhibits or other resources that provide more information about the scenario described in the case. Information provided in an individual question does not apply to the other questions in the case study. A Review Screen will appear at the end of this case study. From the Review Screen, you can review and change your answers before you move to the next exam section. After you leave this case study, you will NOT be able to return to it. To start the case study - To display the first question in this case study, select the "Next" button. To the left of the question, a menu provides links to information such as business requirements, the existing environment, and problem statements. Please read through all this information before answering any questions. When you are ready to answer a question, select the "Question" button to return to the question. Company background and technical environment Current environment - Fabrikam Inc. is a medium-sized company that plans to implement Dynamics 365 Business Central as an ERP system. The company has a development department that will help with the ERP implementation. Most employees work remotely from different countries or regions and speak different languages. The various locations and languages cause issues with the current on-premises software. Planned improvements - Fabrikam Inc. plans to implement new and modern software to manage the company. The company wants to use Business Central because it is cloud-based and meets all company requirements. The company intends to improve reporting and integration functionality by using modern tools such as Power BI and APIs. To reduce the amount of information sent by email, the company plans to expose vendor information to be consumed from external users. Technical specifications - The development department installed Visual Studio Code to create Business Central extensions so the ERP system could be customized according to company needs. All extensions must be developed for the Business Central 2024 wave 1 online version. The development department plans to use telemetry to control the appropriate use of each new development and works directly in licensed sandbox environments supplied by Microsoft. Department-specific requirements The following departments at Fabrikam Inc. have multiple requirements: • Development • Control • Accounting • Quality Development department - The development department designed an extension for the purchase department. Because the developers plan to work with telemetry for monitoring operations, they need the Application Insights information. To accomplish this, the department must add a setting in the corresponding file. The quality department does not want to receive any warning about the Application Insights setting when the extension is compiled. Control department - The control department requires customizations to Business Central by using a per-tenant extension (PTE) named Subcontract Docs. The PTE includes a table named Subcontract Documents. The table has the following fields: ID: A unique identifier - Subcontract No.: Related to the standard Vendors table Description: A short description of a received document Document: A media type that has the document Comments: Comments about the document Date: When the document was imported Amount: Amount related with the imported document Posted: Indicates if the document is managed The extension must be in English - United States (ENU) and Spanish Traditional Sort (ESP) so the application can be used in both languages. The translations must be on the table, not on the page, to avoid repeating them. The control department does not want to use translation files. The control department manager requires a brief guide for the Description and Comments fields when employees create a new record so users know what to include in the fields. The guide must disappear as soon as users add a value in the fields. The Subcontract Documents table must be displayed on a new page named Subcontract Document List through an action from the standard Vendor page. The Amount field, included in the Subcontract Document List, must be formatted in bold format when the record is posted (field Posted = true). The control department also requires a report to display a list of subcontract documents named Subcontract Documents Excel List. The report must meet the following requirements: • Downloads a file only in Microsoft Excel. • Includes a predefined format with two worksheets: one with the posted subcontract documents and another with the unposted subcontract documents. Accounting department - The accounting department plans to use Power BI to analyze information generated by the control department. The accounting department plans to expose an API named API Customer Lines. To improve the performance, the API must use read-only information and work with a Query object to summarize the data. You have the following code: The accounting department must expose data such as the following: The qty column must be the sum of the Outstanding quantity field of Sales Order Lines. It must be in descending order by quantity. The department also exposes a page named Fabrikam Vendor API that includes vendor information from the Vendor table, such as number and name. The API must use the replica database to improve performance. Because Fabrikam Inc. is based in multiple countries and regions, the company periodically must send accounting movements between two dates to the local tax offices named Fabrikam Accounting. The format for this file must be an XML file generated by an XMLport object. For security reasons, it is not possible to receive data from this XMLport. The generated XML file must have a schema like this: Quality department - The quality department requires that every new app or extension is designed to meet standard company guidelines. The quality department plans to follow the standard Business Central data model. The quality development must be able to use triggers correctly. The department must ensure that when a vendor is deleted, the system also removes each record in the Subcontract Documents table related to the vendor. If the subcontract document record has the field Posted = false, it must not be possible to delete the record. The department has a version 1.0.0.1 installed for an extension named Quality Control. The department develops a new version 1.0.0.2 and uses a codeunit with the subtype Upgrade to update it. The department requires the values for AppVersion and DataVersion on the trigger OnUpgradePerCompany after using NavApp.GetCurrentModuleInfo(myinfo). 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.

Illustration for MB-820 question 39 Illustration for MB-820 question 39 Illustration for MB-820 question 39 Illustration for MB-820 question 39
Show Answer
Correct Answer: tableextension 50100 "Vendor Control" extends Vendor trigger OnDelete() error(errLbl)
Explanation:
The logic must run when a vendor is deleted, so it belongs in a tableextension that extends Vendor and uses the OnDelete trigger. If unposted subcontract documents exist, deletion must be blocked, which is enforced by raising an error. If only posted documents exist, they are deleted automatically.

Question 40

HOTSPOT - Case study - This is a case study. Case studies are not timed separately from other exam sections. You can use as much exam time as you would like to complete each case study. However, there might be additional case studies or other exam sections. Manage your time to ensure that you can complete all the exam sections in the time provided. Pay attention to the Exam Progress at the top of the screen so you have sufficient time to complete any exam sections that follow this case study. To answer the case study questions, you will need to reference information that is provided in the case. Case studies and associated questions might contain exhibits or other resources that provide more information about the scenario described in the case. Information provided in an individual question does not apply to the other questions in the case study. A Review Screen will appear at the end of this case study. From the Review Screen, you can review and change your answers before you move to the next exam section. After you leave this case study, you will NOT be able to return to it. To start the case study - To display the first question in this case study, select the "Next" button. To the left of the question, a menu provides links to information such as business requirements, the existing environment, and problem statements. Please read through all this information before answering any questions. When you are ready to answer a question, select the "Question" button to return to the question. Company background and technical environment Current environment - Fabrikam Inc. is a medium-sized company that plans to implement Dynamics 365 Business Central as an ERP system. The company has a development department that will help with the ERP implementation. Most employees work remotely from different countries or regions and speak different languages. The various locations and languages cause issues with the current on-premises software. Planned improvements - Fabrikam Inc. plans to implement new and modern software to manage the company. The company wants to use Business Central because it is cloud-based and meets all company requirements. The company intends to improve reporting and integration functionality by using modern tools such as Power BI and APIs. To reduce the amount of information sent by email, the company plans to expose vendor information to be consumed from external users. Technical specifications - The development department installed Visual Studio Code to create Business Central extensions so the ERP system could be customized according to company needs. All extensions must be developed for the Business Central 2024 wave 1 online version. The development department plans to use telemetry to control the appropriate use of each new development and works directly in licensed sandbox environments supplied by Microsoft. Department-specific requirements The following departments at Fabrikam Inc. have multiple requirements: • Development • Control • Accounting • Quality Development department - The development department designed an extension for the purchase department. Because the developers plan to work with telemetry for monitoring operations, they need the Application Insights information. To accomplish this, the department must add a setting in the corresponding file. The quality department does not want to receive any warning about the Application Insights setting when the extension is compiled. Control department - The control department requires customizations to Business Central by using a per-tenant extension (PTE) named Subcontract Docs. The PTE includes a table named Subcontract Documents. The table has the following fields: ID: A unique identifier - Subcontract No.: Related to the standard Vendors table Description: A short description of a received document Document: A media type that has the document Comments: Comments about the document Date: When the document was imported Amount: Amount related with the imported document Posted: Indicates if the document is managed The extension must be in English - United States (ENU) and Spanish Traditional Sort (ESP) so the application can be used in both languages. The translations must be on the table, not on the page, to avoid repeating them. The control department does not want to use translation files. The control department manager requires a brief guide for the Description and Comments fields when employees create a new record so users know what to include in the fields. The guide must disappear as soon as users add a value in the fields. The Subcontract Documents table must be displayed on a new page named Subcontract Document List through an action from the standard Vendor page. The Amount field, included in the Subcontract Document List, must be formatted in bold format when the record is posted (field Posted = true). The control department also requires a report to display a list of subcontract documents named Subcontract Documents Excel List. The report must meet the following requirements: • Downloads a file only in Microsoft Excel. • Includes a predefined format with two worksheets: one with the posted subcontract documents and another with the unposted subcontract documents. Accounting department - The accounting department plans to use Power BI to analyze information generated by the control department. The accounting department plans to expose an API named API Customer Lines. To improve the performance, the API must use read-only information and work with a Query object to summarize the data. You have the following code: The accounting department must expose data such as the following: The qty column must be the sum of the Outstanding quantity field of Sales Order Lines. It must be in descending order by quantity. The department also exposes a page named Fabrikam Vendor API that includes vendor information from the Vendor table, such as number and name. The API must use the replica database to improve performance. Because Fabrikam Inc. is based in multiple countries and regions, the company periodically must send accounting movements between two dates to the local tax offices named Fabrikam Accounting. The format for this file must be an XML file generated by an XMLport object. For security reasons, it is not possible to receive data from this XMLport. The generated XML file must have a schema like this: Quality department - The quality department requires that every new app or extension is designed to meet standard company guidelines. The quality department plans to follow the standard Business Central data model. The quality development must be able to use triggers correctly. The department must ensure that when a vendor is deleted, the system also removes each record in the Subcontract Documents table related to the vendor. If the subcontract document record has the field Posted = false, it must not be possible to delete the record. The department has a version 1.0.0.1 installed for an extension named Quality Control. The department develops a new version 1.0.0.2 and uses a codeunit with the subtype Upgrade to update it. The department requires the values for AppVersion and DataVersion on the trigger OnUpgradePerCompany after using NavApp.GetCurrentModuleInfo(myinfo). You need to develop the report Subcontract Documents Excel List that is required by the control department. You have the following 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.

Illustration for MB-820 question 40 Illustration for MB-820 question 40 Illustration for MB-820 question 40 Illustration for MB-820 question 40 Illustration for MB-820 question 40
Show Answer
Correct Answer: Statement 1: No Statement 2: Yes Statement 3: Yes
Explanation:
The report must generate only Excel output and include multiple worksheets. Removing the Word layout is required. Setting DefaultRenderingLayout to excelLayout (not DefaultLayout = Excel) is necessary, and enabling ExcelLayoutMultipleDataSheets = true allows separate worksheets. Statement 1 uses an invalid property change and is therefore incorrect.

Question 41

DRAG DROP - You develop a table named Contoso Setup and a page. You plan to use No. Series to automatically assign a unique number to data entries. You set up No. Series on the Vendor Nos. field of the Contoso Setup table. You need to apply the No. Series Design Pattern to the trigger OnInsert(). Which four code segments should you use to develop the solution? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

Illustration for MB-820 question 41
Show Answer
Correct Answer: if "No." = '' then begin ContosoSetup.Get(); ContosoSetup.TestField("Vendor Nos."); NoSeriesManagement.InitSeries(ContosoSetup."Vendor Nos.", xRec."No. Series", 0D, "No.", "No. Series"); end;
Explanation:
The No. Series design pattern initializes a number only when the primary key is empty. The setup record is retrieved, the No. Series field is validated to ensure it is configured, and InitSeries assigns the next number from the configured Vendor Nos. series.

Question 42

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.

Illustration for MB-820 question 42 Illustration for MB-820 question 42
Show Answer
Correct Answer: 1. No 2. Yes 3. No 4. No
Explanation:
Reading data requires InherentPermissions on TableData with 'R' and scope Permissions to grant access independently of the caller. Using Table (not TableData), write permissions ('x'), or lowercase 'r' with scope Both does not resolve the permission error.

$19

Get all 96 questions with detailed answers and explanations

  • Instant download HTML + PDF delivered the moment payment clears.
  • Secure Stripe checkout we never see or store your card details.
  • 7-day refund if files are defective see our refund policy.