MB-820 practice test

1. Question 1 · 1

   A company is deploying Business Central on-premises. The company plans to use a single-tenant deployment architecture. You need to describe how the data is stored and how the Business Central Server is configured. In which two ways should you describe the single-tenant architecture? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   Choose all answers that apply.

   • Each customer has their own Business Central Server.
   • The application and the business data are stored in the same database.
   • Multiple customers share a single Business Central Server.
   • The application and business data are stored in separate databases.
   • Multiple customers share multiple Business Central Server instances.

2. Question 2 · 1

   A company plans to set up a local Business Central Development Docker container. The environment will be used for testing new project ideas. You need to ensure that the most recent Business Central artifact URL has been selected. Which command should you use?

   Choose one answer.

   • Get-BcArtifactUrl -type sandbox -select Current
   • Get-BcArtifactUrl -type sandbox -select Closest
   • Get-BcArtifactUrl -type sandbox -select NextMinor
   • Get-BcArtifactUrl -type sandbox -select NextMajor

3. Question 3 · 1

   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 modify the API Customer List code to obtain the required result. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

   Choose an option for each prompt.

   

   

   

   

   Add two lines, one between lines 8 and 9 with OrderBy = descending("Outstanding Quantity"); and another between lines 24 and 25 with Method = Sum;

   • • Yes
   • • No

   Add three lines: one between line 8 and 9 with OrderBy = descending(qty); another between line 22 and 23 with DataItemTableFilter = "Document Type" = filter('Order'); and another between lines 24 and 25 with Method = Sum;

   • • Yes
   • • No

   Add three lines: one between lines 8 and 9 with OrderBy = descending(qty); another between lines 22 and 23 with DataItemTableFilter = "Document Type" = const('Order'); and another between lines 24 and 25 with Method = Sum;

   • • Yes
   • • No

4. Question 4 · 1

   You are developing an app. You plan to publish the app to Microsoft AppSource. You need to assign an object range for the app. Which object range should you use?

   Choose one answer.

   • custom object within the range 50000 to 59999
   • custom object within the range 50000 to 99999
   • divided by countries and use specific a country within the range 100000 to 999999
   • an object range within the range of 7000000 to 74999999 that is requested from Microsoft
   • free object within the standard range 1 to 49999

5. Question 5 · 1

   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: Filter the page to display only jobs with open or quote status. Add the following comment for internal use: This page does not include completed jobs. Item Ledger Entries action must open the selected job on the page and display it in the UI 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.

   Choose an option for each prompt.

   

   Display status of open or quote.

   • • SourceTableView = sorting(Status) order(ascending)
   • • SourceTableView = where(Status = filter(Open | Quote | Planning));
   • • SourceTableView = where(Status = filter(Open | Quote));

   Add a comment for internal use.

   • • Description = 'This page does not include completed jobs';
   • • ToolTip = 'This page does not include completed jobs';

   Action must open selected job on the page.

   • • RunPageLink = 'Job No.' = FIELD("No.");
   • • RunPageView = 'Job No.' = FIELD("No.");

6. Question 6 · 1

   A company plans to meet new regulatory requirements. The regulator has issued new tax tiers. You need to update the base application table by using a table extension. Which table field property can you change?

   Choose one answer.

   • CalcFormula
   • DecimalPlaces
   • BlankZero
   • AutoFormatType

7. Question 7 · 1

   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.

   Arrange the options in the correct order.

   

   

   • Rename the permission set object to "Sales Person".
   • Change the Assignable property value to true.
   • Add the IncludedPermissionSets = SUPER property.

8. Question 8 · 1

   DRAG DROP - You create a codeunit that works with a table named Boxes. You plan to filter the records and then modify them. You get an error that you do not have permission to work with the Boxes table. You need to assign the Indirect permissions for the Boxes table to the codeunit. Which four code blocks should you use in sequence to assign the correct permission? To answer, move the appropriate code blocks from the list of code blocks to the answer area and arrange them in the correct order.

   Arrange the options in the correct order.

   

   • Permissions =
   • TableData
   • "Boxes" =
   • rm

9. Question 9 · 1

   DRAG DROP - A company plans to deploy Business Central. The company has the following deployment requirements: Use the company hardware architecture to run the deployment. Use sandbox environments to develop extensions. Allow tenants to connect to Shopify with the standard connector. Use Microsoft Power Automate to create a workflow that calls a business event. You need to identify the deployment type for each requirement. Which deployment types should you use? To answer, move the appropriate deployment types to the correct requirements. You may use each deployment type 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.

   Match each destination with an option.

   

   Run on the company hardware.

   • • On-premises
   • • Online

   Use sandbox environments for extensions.

   • • On-premises
   • • Online

   Allow connection to Shopify.

   • • On-premises
   • • Online

   Create a workflow.

   • • On-premises
   • • Online

10. Question 10 · 1

    You plan to write unit test functions to test newly developed functionality in an app. You must create a test codeunit to write the functions. You need to select the property to use for the test codeunit. Which property should you use to ensure that the requirements are fulfilled?

    Choose one answer.

    • SubType
    • Access
    • Description

11. Question 11 · 1

    DRAG DROP - A company owns and operates hotels, restaurants, and stores. When the staff orders materials from the purchasing department, the requests are not directed to the correct approvers. The staff requires a new field named Approver from which they can select the appropriate approver. The field must include the following options: Hotel manager - Restaurant manager - Store manager - Purchasing manager - You need to create the Approver field in the Item table by using an AL extension. 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.

    Arrange the options in the correct order.

    

    • Create an enum object named Approver and include all options.
    • Create a table extension object for an Item table with an Approver field of enum type named Approver in the field section.
    • Create a page extension object that extends the Item Card object. Add the field to the layout section.

12. Question 12 · 1

    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.

    Choose an option for each prompt.

    

    

    Configure [InherentPermissions(PermissionObjectType::Table, Database::"Logistics Setup", 'x', InherentPermissionsScope::Both)] above line 15.

    • • Yes
    • • No

    Configure [InherentPermissions(PermissionObjectType::TableData, Database::"Logistics Setup", 'R', InherentPermissionsScope::Permissions)] above line 15.

    • • Yes
    • • No

    Configure [InherentPermissions(PermissionObjectType::TableData, Database::"Logistics Setup", 'r', InherentPermissionsScope::Both)] above line 15.

    • • Yes
    • • No

13. Question 13 · 1

    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?

    Choose one answer.

    • XML
    • VariableText
    • FixedText

14. Question 14 · 1

    HOTSPOT - You plan to create a table to hold client data. You have the following data integrity requirements: Lookups into other records must be established. Validate if a record exists in a destination record. You need to select the table field property to use for each requirement. Which table field property should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

    Choose an option for each prompt.

    

    Establish lookups into other records.

    • • DataClassification
    • • ExternalAccess
    • • TableRelation
    • • ValidateTableRelation

    Validate if a record exists.

    • • CalcFormula
    • • Access
    • • AccessByPermission
    • • ValidateTableRelation

15. Question 15 · 1

    A company has a task that is performed infrequently. Users often need to look up the procedure to complete the task. The company requires a wizard that leads users through a sequence of steps to complete the task. You need to create the page to enable the wizard creation. Which page type should you use?

    Choose one answer.

    • NavigatePage
    • Card
    • RoleCenter
    • List

Paid access to all 55 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.