exam questions

Exam MB-500 All Questions

View all questions & answers for the MB-500 exam

Exam MB-500 topic 8 question 1 discussion

Actual exam question from Microsoft's MB-500
Question #: 1
Topic #: 8
[All MB-500 Questions]

HOTSPOT -
You need to create the new table for the vendor exclusion list.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Scenario: You must develop a new solution to maintain a Vendor exclusion list for each customer and item combination. The solution must meet the following requirements:
✑ Isolate all new vendor exclusion codes as a new assembly by creating a table named VendExclusions.
✑ Create an index for the table named PrimaryIdx that uses the following fields: CustAccount, ItemId, VendAccount.
✑ Ensure that users can open the Vendor Exclusion list report from the customer master form. The list must display the customer account, Item ID, and Vendor account fields.
Maintain referential integrity with other tables.

Box 1: a table extension for Vendors and relation for the Vendor exclusions

Box 2: RelationShip Type -
Reference:
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/develop-composite-data-entities

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
TM22
Highly Voted 2 years, 5 months ago
Why extension of Vendor table? Relation could be created on the new table. Ans should be: a Relation between the new table and Vendor table and Relationship type
upvoted 11 times
a50dc84
1 year, 4 months ago
i agree.
upvoted 1 times
...
...
salvatagio
Most Recent 8 months, 3 weeks ago
Maintain referential integrity with other tables: - A relation between the Vendor exclusions table and Vendors table - Assign a value to the OnDelete property
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...