A company has two custom tables: Project and ProjectAssignment. They need to create a map so that code can treat these tables as a single logical table. The map should allow fields from both tables to be accessed through a common interface. What should you create?

Create a new table that contains all fields from both tables and then create a map on that table.

Create a view that combines Project and ProjectAssignment, then create a map on that view.

Create a map with Project as the primary table and add ProjectAssignment as a related table, mapping the common fields.

Create a query that joins Project and ProjectAssignment, then create a map that uses that query as its data source.

A company has an existing view, VendOnHold, that shows vendors with a status of OnHold. They need to add a new field, CreditLimit, from the VendTable to the view and also show only vendors with a credit limit greater than zero. The view is used in several forms. What should you do?

Modify the existing view's data source to add the CreditLimit field and set the view's Query property to filter CreditLimit > 0.

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

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

Extend the VendOnHold view by adding the CreditLimit field to the view's data source and adding a range on CreditLimit with a value of '>0'.

A company uses the standard CustomerEntity data entity for integrations. They need to add a custom field, LoyaltyTier, from a custom table CustomerLoyalty to the entity so that the field is included in OData and data import/export. The field must be read-only in the entity. What should you do?

Extend the CustomerEntity data entity by adding a data source for CustomerLoyalty, map the LoyaltyTier field, and set its IsEditable property to No.

Extend the CustomerLoyalty table to add the LoyaltyTier field to the CustomerEntity by using a relation.

Modify the CustomerEntity's primary data source to include the CustomerLoyalty table and set the field's IsEditable property to No.

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

A standard query named CustomerListQuery is used in a form. The company has added a custom field to the CustTable and wants to filter the query by this field. What is the correct way to add the filter without modifying the original query?

Modify the original query to add the range directly.

Create a new query that copies the original and add the filter.

Extend the CustomerListQuery and add a range on the custom field.

Create a view that uses the query and add the filter to the view.

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 3Objective 2

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

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 41–45

41application · medium
A company has two custom tables: Project and ProjectAssignment. They need to create a map so that code can treat these tables as a single logical table. The map should allow fields from both tables to be accessed through a common interface. What should you create?
Select an answer first
42application · medium
A company has an existing view, VendOnHold, that shows vendors with a status of OnHold. They need to add a new field, CreditLimit, from the VendTable to the view and also show only vendors with a credit limit greater than zero. The view is used in several forms. What should you do?
Select an answer first
43application · medium
A company uses the standard CustomerEntity data entity for integrations. They need to add a custom field, LoyaltyTier, from a custom table CustomerLoyalty to the entity so that the field is included in OData and data import/export. The field must be read-only in the entity. What should you do?
Select an answer first
44application · medium
A standard query named CustomerListQuery is used in a form. The company has added a custom field to the CustTable and wants to filter the query by this field. What is the correct way to add the filter without modifying the original query?
Select an answer first
45foundation · easy
When creating a new table in the AOT, which of the following is a valid table property that determines whether the table is stored in the database or is temporary?
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.