An existing query, PurchaseOrderLines, retrieves purchase order lines. The company now needs to also include the vendor name from the VendTable in the query results. The query is used in a report. What should you do?

Extend the PurchaseOrderLine table to add a computed field for the vendor name, then add that field to the query.

Create a new query that copies the existing query and adds VendTable, then update the report to use the new query.

Extend the PurchaseOrderLines query by adding VendTable as a related data source and joining it on the PurchaseOrder.VendorId field.

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

In Dynamics 365 Finance and Operations, what is the primary purpose of a map in the AOT?

To store data in a denormalized format

To create a view of multiple tables

To enforce referential integrity

To define relationships between tables

A company uses the standard SalesTable and SalesLine tables. They need to add a custom field, DiscountOverride, to both tables and expose it in the SalesTable data entity. The field must be editable in the entity. The company also has an existing query, SalesOrderDetails, that is used in a report; they need the field to appear in that query as well. What is the most efficient approach?

Create a new table that has the DiscountOverride field and add it as a related table to SalesTable and SalesLine, then add it to the entity and query.

Modify the SalesTable and SalesLine tables directly to add the field, then add it to the entity and query.

Extend SalesTable and SalesLine to add the field, extend the SalesTable data entity to include the field from SalesTable, and extend the SalesOrderDetails query to include the field from both tables.

Extend SalesTable only to add the field, then add it to the entity and query, and use a computed field on SalesLine to reference it.

When extending a view in the AOT, which of the following can you add to the view extension?

A new field from an existing data source

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

Create a map extension and add the field to it.

Edit the original map directly in the AOT.

Modify the underlying tables to include the field.

Create a new map and copy the original's definition.

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 3Objective 2

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

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 31–35

31application · medium
An existing query, PurchaseOrderLines, retrieves purchase order lines. The company now needs to also include the vendor name from the VendTable in the query results. The query is used in a report. What should you do?
Select an answer first
32foundation · easy
In Dynamics 365 Finance and Operations, what is the primary purpose of a map in the AOT?
Select an answer first
33expert · hard
A company uses the standard SalesTable and SalesLine tables. They need to add a custom field, DiscountOverride, to both tables and expose it in the SalesTable data entity. The field must be editable in the entity. The company also has an existing query, SalesOrderDetails, that is used in a report; they need the field to appear in that query as well. What is the most efficient approach?
Select an answer first
34foundation · easy
When extending a view in the AOT, which of the following can you add to the view extension?
Select an answer first
35foundation · easy
You need to add a new field to an existing map in Dynamics 365 Finance and Operations without modifying the original map. What is the correct approach?
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.