You need to add a new field to an existing table in Dynamics 365 Finance and Operations without modifying the original table. What is the correct approach?

Create a table extension and add the field to it.

Create a new table and copy all data from the original.

Edit the original table directly in the AOT.

An existing query, SalesOrderSummary, retrieves sales order headers and lines. The company now needs to also include the customer name from the CustTable in the query results. The query is used in a report. What should you do?

Create a new query that copies the existing query's data sources and adds CustTable, then update the report to use the new query.

Extend the SalesTable table to add a computed field for the customer name, then add that field to the query.

Modify the existing query's data source to add CustTable as a data source and set the query's JoinMode property to InnerJoin.

Extend the SalesOrderSummary query by adding CustTable as a related data source and joining it on the SalesOrder.CustomerId field.

A company needs to import customer data from an external system into Dynamics 365 Finance and Operations. The external system provides fields that are not present in the standard Customer data entity. They want to use the standard data import framework. What should you do?

Extend the Customer data entity and add the custom fields to the extension.

Use a table import instead of a data entity import.

Modify the Customer data entity directly to add the custom fields.

Create a new data entity that includes the standard fields and the custom fields, and use it for import.

A company has a custom table named ProjectBudget that needs to be used in code that currently works with the standard ProjectTable. The developers want to write generic code that can handle both tables without knowing the specific table type. What should they create?

Create a data entity that combines both tables and use it in code.

Create a map that includes both ProjectTable and ProjectBudget, and write code against the map.

Create a query that joins the two tables and use the query in code.

Create a view that unions the two tables and use the view in code.

An existing map, AddressMap, maps the Address and PostalAddress tables. The company now needs to also map a new custom table, AlternativeAddress, to the same map so that code can use the map to access all three tables. What should you do?

Create a new map that includes all three tables and update all code to use the new map.

Modify the AddressMap map's primary table to be AlternativeAddress and add the other two tables as related.

Create a view that combines all three tables and then add that view to the map.

Extend the AddressMap map by adding AlternativeAddress as a related table and mapping the common fields.

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 3Objective 2

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

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 6–10

6foundation · easy
You need to add a new field to an existing table in Dynamics 365 Finance and Operations without modifying the original table. What is the correct approach?
Select an answer first
7application · medium
An existing query, SalesOrderSummary, retrieves sales order headers and lines. The company now needs to also include the customer name from the CustTable in the query results. The query is used in a report. What should you do?
Select an answer first
8application · medium
A company needs to import customer data from an external system into Dynamics 365 Finance and Operations. The external system provides fields that are not present in the standard Customer data entity. They want to use the standard data import framework. What should you do?
Select an answer first
9application · medium
A company has a custom table named ProjectBudget that needs to be used in code that currently works with the standard ProjectTable. The developers want to write generic code that can handle both tables without knowing the specific table type. What should they create?
Select an answer first
10application · medium
An existing map, AddressMap, maps the Address and PostalAddress tables. The company now needs to also map a new custom table, AlternativeAddress, to the same map so that code can use the map to access all three tables. What should you do?
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.