Microsoft MB-500 Practice Exams
Last updated on Nov 16,2026- Exam Code: MB-500
- Exam Name: Microsoft Dynamics 365: Finance and Operations Apps Developer Exam
- Certification Provider: Microsoft
- Latest update: Nov 16,2026
DRAG DROP
You are a Dynamics 365 Finance and Operations developer.
The sales department manager must to be able to view total customers by region and total sales by regions.
You need to build key performance indicators (KPIs) and display them on a tile in the application.
How should you model the KPI? To answer, drag the appropriate objects to the correct KPI components. Each object may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

DRAG DROP
You use Dynamics 365 Finance.
You must loop through the customers table and display in the Ul the customer account numbers that meet the following requirements:
• Include the first 100 customers.
• The account numbers must be greater than 1.000.
• Order the results from larger to smaller by the customer account number.
You need to write the SQL statement by using SQL in X++.
Which four statements should you include in sequence;1 To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

DRAG DROP
You use Dynamics 365 Finance.
You must loop through the customers table and display in the Ul the customer account numbers that meet the following requirements:
• Include the first 100 customers.
• The account numbers must be greater than 1.000.
• Order the results from larger to smaller by the customer account number.
You need to write the SQL statement by using SQL in X++.
Which four statements should you include in sequence;1 To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

A company uses Dynamics 365 Finance.
You are customizing elements for the extended data types (EDTs) shown in the following table.

You have a table named WorkCalendar. The table has a column named BasicCalendailD that uses the BasicCalendarlD EDT. You need to increase the length of the column by using an extension.
Solution: Create an extension for CalendarName.
Does the solution meet the goal?
- A . Yes
- B . No
The warehouse manager at Contoso, Ltd. wants to display a tile in the user interface that will show total RAFs per hour.
You need to create a key performance indicator (KPI) that meets these requirements.
What two components should you create? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . aggregate dimensions
- B . data entity
- C . aggregate measurements
- D . TempDB table
You are a Dynamics 365 Finance developer. You create an integer variable named totalSales.
Which three code segments can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

- A . Option A
- B . Option B
- C . Option C
- D . Option D
You have a table in which multiple properties must be changed. Multiple table properties are locked down at the base table and must not be overwritten.
You need to modify the table properties by extending the table.
Which table property can you populate in a table extension by using the property sheet?
- A . Created by
- B . Table group
- C . Configuration key
- D . Cache lookup
DRAG DROP
A company is implementing Dynamics 365 Finance.
You are extending the standard fixed asset functionality to develop a new feature.
You need to select the appropriate components for the solution.
Which components should you use? To answer, drag the appropriate components to the correct requirements. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

A company uses Dynamics 365 Finance
You implement the Insert method for a table you create.
The class must meet the following requirements:
• If FieldA is equal to ‘Hello." then FieldB must save the integer value 10.
• If FieldA is equal to "World," then FieldB must save the integer value 20.
• Otherwise FieldB must save the integer 0.
You need to implement the code
Which two code segments can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A)

B)

C)

D)

- A . Option A
- B . Option B
- C . Option C
- D . Option D
HOTSPOT
You are a Dynamics 365 Finance developer.
You need to create a security rule that meets the following requirements:
✑ Provide the same permissions as HcmWorkerActionHireRead
✑ Assign the Update level access and the HcmHumanResourceMamager Role
Which settings should you use? To answer, select the appropriate option in the answer area. NOTE: Each correct selection is worth one point.



