An existing view, SalesByCustomer, shows total sales per customer. The company now needs to also show the customer's credit limit from the CustTable. The view currently uses SalesTable as its data source. What should you do?

Extend the SalesTable table to add a computed field for CreditLimit, then add that field to the view.

Extend the SalesByCustomer view by adding CustTable as a related data source and mapping the CreditLimit field.

Create a new view that copies the existing view and adds the CreditLimit field, then update all forms to use the new view.

Modify the existing view's data source to add the CreditLimit field directly to the SalesTable data source.

A company has a standard map named CustomerMap that is used in several legacy code paths. They have created a custom table named CustomerLoyalty that shares the same key fields as CustTable. They need to make the custom table work with the existing code that uses CustomerMap, but they cannot modify the existing code. What should they do?

Extend the CustomerMap and add the CustomerLoyalty table to the map extension.

Create a new map that includes both tables and update all code references.

Modify the CustomerMap directly to add the CustomerLoyalty table.

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

A company uses the standard SalesOrderHeader view in their application. They need to add a custom field from the SalesTable extension to this view so that it appears in reports and forms that use the view. What is the recommended way to achieve this?

Create a data entity that includes the custom field and use it instead of the view.

Modify the SalesOrderHeader view directly by adding the custom field.

Extend the SalesOrderHeader view and add the custom field to the extension.

Create a new view that duplicates the SalesOrderHeader view and add the custom field.

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 3Objective 2

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

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 26–30

26foundation · easy
When creating a data entity in the AOT, which of the following is a required element?
Select an answer first
27application · medium
An existing view, SalesByCustomer, shows total sales per customer. The company now needs to also show the customer's credit limit from the CustTable. The view currently uses SalesTable as its data source. What should you do?
Select an answer first
28expert · hard
A company has a standard map named CustomerMap that is used in several legacy code paths. They have created a custom table named CustomerLoyalty that shares the same key fields as CustTable. They need to make the custom table work with the existing code that uses CustomerMap, but they cannot modify the existing code. What should they do?
Select an answer first
29foundation · easy
Which of the following elements can be defined in a query to filter the records that are returned?
Select an answer first
30application · medium
A company uses the standard SalesOrderHeader view in their application. They need to add a custom field from the SalesTable extension to this view so that it appears in reports and forms that use the view. What is the recommended way to achieve this?
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.

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

Questions 26–30

When creating a data entity in the AOT, which of the following is a required element?

An existing view, SalesByCustomer, shows total sales per customer. The company now needs to also show the customer's credit limit from the CustTable. The view currently uses SalesTable as its data source. What should you do?

Which of the following elements can be defined in a query to filter the records that are returned?

A company uses the standard SalesOrderHeader view in their application. They need to add a custom field from the SalesTable extension to this view so that it appears in reports and forms that use the view. What is the recommended way to achieve this?

Keep studying — Design and develop AOT elements