Microsoft

MB-820 Free Practice Questions — Page 5

Question 42

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 42
Show Answer
Correct Answer: OnInitReport OnPostDataItem CurrReport.Quit()
Explanation:
OnInitReport runs when the report is initialized/loaded. OnPostDataItem runs after the data item has been iterated completely. CurrReport.Quit() immediately terminates the report, skipping the remainder of its execution.

Question 43

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 43 Illustration for MB-820 question 43 Illustration for MB-820 question 43 Illustration for MB-820 question 43
Show Answer
Correct Answer: tableextension 50100 "Vendor Control" extends Vendor trigger OnDelete() error(errLbl)
Explanation:
Use a table extension on Vendor to intercept vendor deletion. Implement the OnDelete trigger. If related unposted subcontract documents exist, block deletion with error(). Otherwise delete related subcontract documents.

Question 44

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 44 Illustration for MB-820 question 44 Illustration for MB-820 question 44 Illustration for MB-820 question 44 Illustration for MB-820 question 44
Show Answer
Correct Answer: 1. No 2. Yes 3. Yes
Explanation:
The report must only render Excel and produce multiple worksheets. Set DefaultRenderingLayout = excelLayout and enable ExcelLayoutMultipleDataSheets = true. Removing the Word layout is optional for functionality; changing DefaultRenderingLayout to Excel and enabling multiple sheets satisfies the requirements.

Question 45

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 45
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 standard No. Series OnInsert pattern checks for an empty No., loads setup, verifies the configured No. Series field, then initializes the number series using the setup's Vendor Nos. field.

Question 46

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 46 Illustration for MB-820 question 46
Show Answer
Correct Answer: 1. No 2. Yes 3. No 4. No
Explanation:
The code only reads from the Logistics Setup table, so TableData read permission is required. Uppercase 'R' grants direct inherent read permission. Lowercase 'r' is indirect and still relies on caller permissions. Using PermissionObjectType::Table does not grant data access.

Question 47

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 evaluate the version values of the Quality Control extension to decide how the quality department must update it. Which two values can you obtain in the evaluation? Each correct answer presents part of the solution. (Choose two.) NOTE: Each correct selection is worth one point.

A. AppVersion = 1.0.0.1
B. AppVersion = 1.0.0.2
C. DataVersion = 0.0.0.0
D. DataVersion = 1.0.0.1
E. DataVersion = 1.0.0.2
Show Answer
Correct Answer: B, D
Explanation:
During an upgrade to version 1.0.0.2, NavApp.GetCurrentModuleInfo returns AppVersion as the currently installed app version (1.0.0.2), while DataVersion represents the version of the data before the upgrade, which is the previously installed version (1.0.0.1).

Question 48

A company uses Business Central. The company plans to use the AL object model in Business Central to extend the Base Application. You need to extend the objects. Which two objects can you extend? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.

A. Codeunit
B. Report
C. Query
D. API page
E. Enum
Show Answer
Correct Answer: B, E
Explanation:
In Business Central AL, object extension types include reportextension and enumextension, allowing existing reports and enums in the Base Application to be extended. There is no codeunitextension object, and queries and API pages are not extended using dedicated extension object types in the same way.

Question 49

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 creates a Business Central app and a table named MyTable to store records when sales orders are posted. Users report the following issues: • The users receive permission errors related to MyTable. • Users are no longer able to post sales orders since installing the new app. • The users cannot access the list page created in MyTable. You need to resolve the user issues without creating new permission sets. You must use the principle of least privilege. Solution: Assign a SUPER permission set. Does the solution meet the goal?

A. Yes
B. No
Show Answer
Correct Answer: B
Explanation:
Assigning the SUPER permission set grants unrestricted access and violates the principle of least privilege. The requirement is to resolve the permission issues without creating new permission sets while still following least privilege, which would typically involve assigning an appropriate existing permission set or using permission properties in the app, not SUPER.

Question 50

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?

A. NavigatePage
B. Card
C. RoleCenter
D. List
Show Answer
Correct Answer: A
Explanation:
A NavigatePage is specifically designed to implement wizard-style experiences (assisted setup) that guide users through a sequence of steps for infrequent or complex tasks. Card pages are for editing a single record, RoleCenter pages provide the user's home/dashboard, and List pages display collections of records.

Question 51

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
Show Answer
Correct Answer: B
Explanation:
Use the XMLport Format property value 'VariableText' to export data as CSV or other delimited text with non-fixed field lengths and widths. 'FixedText' is for fixed-width text files, and 'XML' produces XML output rather than CSV.

$19

Get all 101 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.