A retail company needs to display a list of customers with their total sales amounts. The data comes from the CustTable and SalesTable tables. The list will be used in a new form and also in an OData feed for external reporting. You want to avoid duplicating the logic. What should you create?

Create a query that joins CustTable and SalesTable, and use that query in both the form and the OData feed.

Create a data entity directly that joins CustTable and SalesTable and use it in the form.

Create a view that joins CustTable and SalesTable with an aggregated sales amount, and use the view in the form and as the data source for a data entity.

Create a map between CustTable and SalesTable and use the map in the form and OData.

A company uses the standard InventTable to manage inventory items. They need to add a custom field, StorageTemperature, to track temperature requirements. The field must appear in the InventTable form and be available in the InventTable data entity for integration. What is the recommended approach?

Create a new table that has the StorageTemperature field and add it as a related table to the InventTable form.

Create a new data entity that includes the StorageTemperature field and update the integration to use it.

Extend the InventTable table to add the StorageTemperature field, then extend the InventTable data entity to include the field.

Modify the InventTable table to add the field directly and then add the field to the data entity.

In Dynamics 365 Finance and Operations, what is the primary purpose of a data entity?

To provide a simplified, reusable abstraction for data import/export and integration

To define the physical database schema

To store data in a denormalized format

A company needs to store information about equipment maintenance schedules. They have an existing table for equipment (EquipmentTable) and need to store multiple maintenance records per equipment. The records will be displayed in a form and also used in a report. What should you create?

Create a query that joins EquipmentTable with a new table, but do not create a view.

Create a new table named MaintenanceSchedule with a foreign key to EquipmentTable, and create a view to join them for the report.

Create a data entity that includes both tables and use it in the form.

Add multiple maintenance schedule fields to the EquipmentTable.

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 3Objective 2

Create and Extend the Data Model MB-500 Practice Questions (Page 3)

Part of the Design and develop AOT elements domain, which accounts for 15–20% of the MB-500 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~6–13 in this domain), expect 2–4 from this objective — we provide 46 practice questions to prepare you well beyond it. (estimate)

46questions here

10free pages

10concepts

15–20%of the exam

Questions 11–15

11application · medium
A retail company needs to display a list of customers with their total sales amounts. The data comes from the CustTable and SalesTable tables. The list will be used in a new form and also in an OData feed for external reporting. You want to avoid duplicating the logic. What should you create?
Select an answer first
12foundation · easy
When creating a view in the AOT, which of the following elements can you define to control which records are included in the view?
Select an answer first
13application · medium
A company uses the standard InventTable to manage inventory items. They need to add a custom field, StorageTemperature, to track temperature requirements. The field must appear in the InventTable form and be available in the InventTable data entity for integration. What is the recommended approach?
Select an answer first
14foundation · easy
In Dynamics 365 Finance and Operations, what is the primary purpose of a data entity?
Select an answer first
15application · medium
A company needs to store information about equipment maintenance schedules. They have an existing table for equipment (EquipmentTable) and need to store multiple maintenance records per equipment. The records will be displayed in a form and also used in a report. What should you create?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to MB-500

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “MB-500” is a trademark of its owner, used for identification only.