Microsoft Updated MB-500 Exam Questions and Answers by margo

Box 1: Table extension

Isolate all new vendor exclusion codes as a new assembly by creating a table named VendExclusions.

Implement the Excel integration for the Vendor Exclusion List form.

The table extension object allows you to add additional fields or to change some properties on a table provided by the Dynamics 365 Business Central service. In this way, you can add data to the same table and treat it as a single table.

Box 2: Unique key

Create an index for the table named PrimaryIdx that uses the following fields: CustAccount, ItemId, VendAccount.

Box 3: Build and synchronize the database.

A project property lets you specify that the synchronize operation for the database should be performed every time that you build the project. This can be useful when you’re making changes to the table structure for an application. Each time that you build, you will know that the database is synchronized with the tables as they are defined in the project.

SQL Server Reporting Services

Controller class

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

A list page presents a set of data on a user interface that is optimized so that you can browse records, find the right record, and then take an action upon that record. The list page lets the user search, filter, and sort the data. FactBoxes on the right side of the grid show related data for the active record. Actions that are relevant to the record are located on the ActionPane at the top of the page.

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.