Free Microsoft MB-820 Exam Questions

Question 1

A company has extended Business Central.You plan to submit the extension to AppSource.You need to ensure that an application meets the technical requirements before submitting it for validation.Which three actions should you perform? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

A : Use the OnBeforeCompanyOpen event for improved sign in time

B : Include extension translation files with the submission.

C : Ensure the app file is digitally signed

D : Code all date fields in the mm-dd-yyyy format

E : Use data classification on all tables and extension fields.

Answer: B,C,E

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 need to add a property to the Description and Comments fields with corresponding values for the control department manager.Which property should you add?

A : Description

B : Caption

C : ToolTip

D : InstructionalText

Answer: C

Question 4

A company has extended Business Central.You plan to submit the extension to AppSource.You need to ensure that an application meets the technical requirements before submitting it for validation.Which three actions should you perform? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

A : Use the OnBeforeCompanyOpen event for improved sign in time

B : Include extension translation files with the submission.

C : Ensure the app file is digitally signed

D : Code all date fields in the mm-dd-yyyy format

E : Use data classification on all tables and extension fields.

Answer: B,C,E

Question 5

A developer needs to set up a development environment for Business Central online on their local machine. They want to leverage Docker containers for isolation and portability.

Which combination of tools and configurations should they use to achieve this?

A : Install Visual Studio Code, the AL extension, and configure Docker with the official Microsoft Dynamics 365 Business Central developer container image.

B : Install Visual Studio with Dynamics 365 Business Central development tools, set up a local SQL Server instance, and configure Docker with a custom-built container image containing necessary components.

C : Utilize the Business Central web client developer tools within the online environment, connect to an external SQL database, and develop extensions directly in the browser.

D : Deploy the development environment onto an Azure virtual machine with pre-installed tools and configurations, utilizing Visual Studio and SQL Server Management Studio.

Answer: A