Free Microsoft MB-820 Practice Exams

Question #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.

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

Reveal Solution Hide Solution

Correct Answer: A, B
A, B

Explanation:

In a single-tenant deployment architecture of Business Central on-premises, the following characteristics describe how the data is stored and how the Business Central Server is configured: The application and the business data are stored in the same database (B): In a single-tenant architecture, each tenant (which typically corresponds to a single customer) has its own dedicated database. This database contains both the application objects (such as pages, reports, codeunits, etc.) and the business data (such as customer, vendor, and transaction records). This setup ensures that each tenant’s data is isolated and can be managed independently.

The application and business data are stored in separate databases (D): While (B) is a characteristic of a single-tenant deployment, it’s important to clarify that in some configurations, the application objects can be stored in a separate database from the business data. This approach can be used for easier maintenance and upgrades of the application code without affecting the business data. However, each tenant still has its own set of databases, maintaining the single-tenancy model.

The other options provided do not accurately describe a single-tenant architecture:

Each customer has their own Business Central Server (A): This statement might be misleading. In a single-tenant deployment, while each customer has their own database, they do not necessarily have their own Business Central Server instance. Multiple databases (tenants) can be hosted on a single server instance, although they are not shared across customers.

Multiple customers share a single Business Central Server (C) and Multiple customers share multiple Business Central Server instances (E): These options describe a multi-tenant architecture rather than

a single-tenant one. In a multi-tenant setup, multiple customers (tenants) can share the same server instance and even the same application database, with data isolation ensured at the application level.

Question #2

Topic 1, Case Study Alpine Ski House

Overview

Alpine Ski House is a company that owns and operates hotels, restaurants, and stores.

Currently, the company uses the following software and interlace:

• 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 serval 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.

The company is moving from a different system to 8usiness 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.

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 61 to analyze departmental information. The database must be configured to provide optimal performance.

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 end to connect to the custom API.

• A developer provides the following details for the API page:

APIPublisher = ‘alpine’;

APIGroup – ‘integration’;

APIVersion – ‘v2.6’;

fntityName ■ ‘room’;

EntitySetName = ‘rooms’;

• 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: o Some web services must be published automatically.

o The version of the specified application’s metadata must be obtained in AL language.

o 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

o The table definition in the Room Incident table must autofill the Incident Date when the housekeeping team inserts a new record.

o The value for Incident Date must be the work date configured in the Business Central online client.

• Status: Includes the following options lo identify the status of the incident:

o Open: When the Room Incident is created

o In Progress: When someone starts repair work

o 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

o The stored picture must be downloadable from a menu action.

o A Room Incident page must be developed to contain the download action.

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 code unit 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

The purchasing department requites 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:

o a header with common information

o 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 01 quality issues is received, the entity must create a non-conformity document in the system.

The following information must be nick the document:

• Non-conformity Number: must use the No.

Series table from Business Central online to manage this field and use these features:

o Alphanumeric values

o Number format that includes "NO 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:

o Be an existing receipt No.

o 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 nonconformity statuses, such as:

o Open

o Notified

o Closed

• Lines must contain the following details:

o Item No.: item received (for existing inventory items only)

o Description: item description

0 Quantity: non-conforming quantity

0 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.

HOTSPOT

You need to download a stored picture from the Room Incident 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.

Reveal Solution Hide Solution

Question #3

You need to create the access modifier for IssueTotal.

Which variable declaration should you use?

A . Protected vat IssueTotal: Decimal
B . Internal var IssueTotal: Decimal
C . Public var IssueTotal: Decimal
D . Local var IssueTotal: Decimal
E . Var IssueTotal; Decimal

Reveal Solution Hide Solution

Correct Answer: B
B

Explanation:

In Business Central development using AL (the language for Business Central extensions), the use of access modifiers defines how variables and procedures are accessed within and outside of an object or codeunit.

Access Modifiers in AL:

Public: A public variable can be accessed from any object or codeunit within the same module or extension.

Protected: This restricts access to the current object and objects that inherit from the current object. However, in AL (at least in versions used for Business Central), the Protected access modifier is used with methods but not variables.

Internal: This modifier restricts the visibility to the current extension. This means that variables or methods declared as internal can only be accessed from within the same extension. This is appropriate when you want to provide functionality that is shared within the extension but not exposed externally.

Local: This restricts the variable or method to the current object or method where it is declared. It cannot be accessed from anywhere else, even within the same extension. Scenario Justification:

In the scenario for Contoso, Ltd., IssueTotal is a global variable in the ISSUE BASE extension, and the ISSUE EXT extension needs to access it. Therefore, the variable cannot be declared as Local, because this would restrict access to just the current object (or method).

Using Public would expose the variable outside of the extension, which is unnecessary because you only want other parts of the extension (specifically the ISSUE EXT extension) to have access.

The best choice in this case is Internal because it restricts access to the variable to within the same extension, which includes the base extension and any dependent extensions like ISSUE EXT. It strikes the right balance between visibility and encapsulation. Microsoft Dynamics 365 Business Central Developer

DRAG DROP:

Access Modifiers in AL: Microsoft’s documentation on AL provides the details on access modifiers, where it is specified that internal variables can be accessed within the extension, and the public variable is accessible across all extensions 【 source: Microsoft Learn on AL Programming 】 .

Best Practices for AL Development: Business Central development best practices suggest keeping variables internal unless they need to be accessed outside of the current extension 【 source: Microsoft Learn on AL development guidelines 】 .

Question #4

HOTSPOT

You need to define the properties of the comments field of the Non-conformity page.

How should you complete the code segment? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Question #5

HOTSPOT

You need to write an Upgrade codeunit and use the DataTransfer object to handle the data upgrade.

Which solution should you use for each requirement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Question #6

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.

Reveal Solution Hide Solution

Question #7

You need to define the data types for the fields of the N on-conformity table.

Which two data types should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A . Integer for the N on-conformity Number field
B . Date Time for the Non-Conformity Date field
C . Char for the Non-Conformity Number field
D . Date for the Non-Conformity Date field
E . Code for the Non-Conformity Number field

Reveal Solution Hide Solution

Question #8

You need to determine If you have unwanted incoming web service calls in your tenant during the last seven days.

Which two KQL queries should you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A)

B)

C)

D)

E)

A . Option A
B . Option B
C . Option C
D . Option D

Reveal Solution Hide Solution

Correct Answer: AC
AC

Explanation:

The task is to identify unwanted incoming web service calls during the last seven days. To do this, we

need to look at KQL (Kusto Query Language) queries that would filter out web service calls based on

the timestamp (to ensure the calls are within the last seven days) and by certain characteristics that

would indicate they are unwanted, such as the wrong type of protocol (SOAP in this case, as Contoso

Ltd. plans to dismiss using it).

Looking at the options:

Option A: This query selects all traces where the timestamp is within the last 7 days and where the custom dimension has a value of ‘RT0008’, and where the category is either ‘ODataV4’, ‘ODataV3’, or ‘Api’. This query would show all API calls except SOAP, so it does not directly answer the question about unwanted calls.

Option B: This query filters for traces with a timestamp within the last 7 days, where ‘RT0008’ is present, and specifically looks for the category ‘SOAP’. This query is correct because it directly targets SOAP calls, which are the unwanted calls according to Contoso Ltd.’s plans.

Option C: Similar to option B, this query filters for traces within the last 7 days and looks for ‘RT0008’ but uses the equality operator for the category ‘SOAP’. This would also correctly return the unwanted SOAP calls.

Option D: This query also filters for traces within the last 7 days, but it excludes the ‘ODataV4’ category, which doesn’t necessarily target the unwanted SOAP calls.

Option E: This query selects traces where the timestamp is within the last 7 days and the custom dimension has ‘RT0008’. However, it filters out categories ‘ODataV4’ and ‘Api’, which does not directly help in identifying the unwanted SOAP calls.

Therefore, the queries that should be used to determine if there are unwanted incoming web service calls (SOAP calls) in the tenant during the last seven days are Options B and

C. These queries are specific to identifying SOAP protocol usage, which is what Contoso Ltd. considers unwanted.

Question #9

You need to call the Issue API action from the mobile application.

Which action should you use?

A . POST/issues (88122e0e-5796-ec11-bb87-000d3a392eb5yMicrosoit.NAV.copy
B . PATCH /issues {88122 eOe-5796-ed 1 -bb87-000d3a392eb5)/Mkrosotl.NAV.Copy
C . POST /issues (88122e0e-5796-ec11 -bb87-000d3a392eb5)/Copy
D . POST /issues (88122e0e-5796-ec11 -bb87-000d3a392eb5)/copy
E . POST/issues(88122e0e-5796-ec11-bb87-000d3a392eb5)/MicrosoftNAV.Copy

Reveal Solution Hide Solution

Question #10

HOTSPOT

You need to log an error in telemetry when the business process defined in the custom application developed for Contoso, Ltd fails.

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.

Reveal Solution Hide Solution