Free Microsoft MB-820 Exam Questions

Question 1

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 2

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

DEF Manufacturing wants to track their inventory turnover rate for different product categories across various warehouse locations. You need to create a report that shows the average days inventory on hand and inventory turnover rate for each category at each location.

Available Data Items:

Inventory (Item No., Location Code, Quantity, Receipt Date)

Item (Item No., Category)

Which query design will effectively calculate and display the desired information?

A : Link Inventory to Item on Item No., calculate the difference between Receipt Date and today's date in a CALCULATED field, use GROUP BY Location and Category, and finally aggregate AVG(Days On Hand) and calculate Inventory Turnover Rate based on the average.

B : Create separate queries for each location and category, calculate Days On Hand and Inventory Turnover Rate within each query, and then combine the results in a report.

C : Use a temporary table to store all inventory data, add calculated fields for Days On Hand and Inventory Turnover Rate based on formulas, and finally GROUP BY Location and Category within the temporary table.

D : Loop through all locations and categories in a codeunit, calculate Days On Hand and Inventory Turnover Rate for each combination within the loop and display the results.

Answer: A