Practice MB-820 Exam Online

Question 1

A company wants to track the total number of sales orders placed for each customer in the current month. Existing reports only show historical data. You need to develop a solution using AL to achieve this.

Which of the following options is the BEST approach to implement this data manipulation in Business Central using AL?

A : Create a new table to store monthly sales order data for each customer.

B : Add a new field to the "Sales Order" table to store the current month for each order.

C : Extend the "Sales Order" table with a calculated field that shows the total count of orders for the current month for each customer.

D : Use the "CRON Trigger" to run a job every day that calculates and stores the monthly sales order count for each customer.

Answer: C

Question 2

Retail wants to identify their top selling items for each customer group and region. You need to create a report that shows the top 10 items (ranked by quantity) along with their total sales amount for each combination of customer group and region.

Available Data Items:

Customer (Customer No., Customer Group, Region)

Sales Order Header (Sales Order No., Customer No., Order Date)

Sales Order Line (Sales Order No., Item No., Quantity, Unit Price)

Item (Item No., Description)

Which query design will effectively achieve this data breakdown and display the top items per combination?

A : Link Sales Order Header to Sales Order Line and Customer on their respective relationships, filter for the current year, use GROUP BY Customer Group, Region, and Item No., aggregate SUM(Quantity) and SUM(Quantity * Unit Price), and finally TOP 10 based on Quantity within each Group and Region.

B : Create separate queries for each customer group and region, rank items by quantity within each query, and then combine the results into a single report showing the top 10 items for each.

C : Use temporary tables to store intermediate data for each customer group and region, calculate rankings and total sales within the tables, and finally display the top 10 items from each table in a report.

D : Loop through all customer groups and regions in a codeunit, retrieve relevant sales data and rank items within each combination, and finally display the top 10 items in a report.

Answer: A

Question 3

You create a page with the PageType property set to RoleCenter.

You navigate through the different sections of the page.

You need to add functionalities to the page.

What should you do?

A : Define actions in the area (reporting) before actions in the area (creation).

B : Define the navigation menu in the area(processing).

C : Define the navigation bar in the area (embedding).

D : Add a source table on the Role Center page.

Answer: A

Question 4

ABC Company uses Dynamics 365 Business Central to manage their purchasing activities. You, as a developer, are tasked with creating a query that retrieves all open purchase orders due within the next 30 days.

Available Data Items:

Purchase Order Header (Purchase Order No., Due Date, Status)

Purchase Order Line (Purchase Order No., Item No., Quantity)

Which filter criteria should be applied in the query to achieve the desired result?

A : Filter on Purchase Order Header."Status" equal to "Open" and Purchase Order Header."Due Date" less than or equal to the current date + 30 days.

B : Filter on Purchase Order Line."Quantity" greater than 0 and Purchase Order Line."Due Date" less than or equal to the current date + 30 days.

C : Filter on Purchase Order Header."Status" equal to "Open" and create a calculated field in Purchase Order Header to calculate the remaining days until due date, then filter on this field less than or equal to 30.

D : Use a temporary table to store all open purchase orders and then filter the temporary table on "Due Date" less than or equal to the current date + 30 days.

Answer: A

Question 5

A manufacturing company wants to automatically assign serial numbers to newly created production orders based on a specific format:

• The format starts with the product code.

• It includes a sequential number starting from 1 for each product code.

• It's padded with leading zeros to reach a total length of 10 characters.

You need to develop an AL function to achieve this serial number generation.

Which of the following AL expressions BEST represents the logic for creating the serial numbers?

A : Code snippet

'PR-' + Item.Code + STRZERO(ProductionOrder.COUNT(ProdOrder where Item.Code = CurrentProdOrder.ItemCode) + 1, 5)

B : Code snippet

'PR-' + Item.Code + FORMAT(ProductionOrder.COUNT(ProdOrder where Item.Code = CurrentProdOrder.ItemCode) + 1, '00000')

C : Code snippet

ProductionOrder.SerialNo := 'PR-' + Item.Code + REPLICATE('0', 10 - (STRLEN(Item.Code) + STRLEN(ProductionOrder.COUNT(ProdOrder where Item.Code = CurrentProdOrder.ItemCode) + 1)))

D : Code snippet

serialNo := 'PR-' + Item.Code + FORMAT(ProductionOrder.NEXT(SerialNo), '00000');

ProductionOrder.SerialNo := serialNo;

Answer: B

Name:	Microsoft Certified Dynamics 365 Business Central Developer Associate
Exam Code:	MB-820
Certification:	Microsoft Dynamics 365
Vendor:	Microsoft
Total Questions:	323
Last Updated:	Sep 04, 2026

Microsoft MB-820 Answers