A company is importing vendor data from a CSV file. The source file has a column named 'VendorName', but the target entity field is 'Name'. You need to ensure the import maps the source column to the correct target field. What should you do?

Enable change tracking on the vendor entity.

Create a composite data entity for vendors.

Modify the field mapping in the data project to map VendorName to Name.

Rename the column in the source file to 'Name'.

How do you configure a data project to run automatically on a recurring schedule?

By using Power Automate to trigger the data project

By creating a batch job in Lifecycle Services

By scheduling a SQL Server Agent job

By setting up a recurring data job in the Data management workspace

What is the purpose of enabling change tracking for a data entity in Dynamics 365 Finance and Operations?

To automatically back up the entity's data

To prevent unauthorized users from modifying data

To identify which records have been created, updated, or deleted since a point in time

To improve query performance on the entity

A data import job failed, and the support team needs to identify which records failed and why. They also need to re-import only the failed records without re-running the entire job. What should they do?

Use the job history to view the failed records, then create a new data project with a filter to import only those records.

Use the change tracking log to identify failed records and re-import them.

Use the aggregate entity to see which records failed and then manually fix them in the source file.

Re-run the entire job with the same data file, and the system will skip records that already exist.

A manufacturing company wants to export a summary of inventory balances by warehouse and item to an external reporting system. The report should show only aggregated quantities, not individual transactions. You need to create a data entity that provides this grouped data for export. What should you create?

A composite data entity that includes all inventory transactions.

Enable change tracking on the inventory transaction entity.

A regular data entity that exposes the inventory transaction table.

An aggregate data entity based on a query that groups inventory transactions by warehouse and item.

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 6Objective 3

Implement Data Management MB-500 Practice Questions (Page 1)

Part of the Integrate and manage data solutions 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–3 from this objective — we provide 33 practice questions to prepare you well beyond it. (estimate)

33questions here

7free pages

7concepts

15–20%of the exam

Questions 1–5

1application · medium
A company is importing vendor data from a CSV file. The source file has a column named 'VendorName', but the target entity field is 'Name'. You need to ensure the import maps the source column to the correct target field. What should you do?
Select an answer first
2foundation · easy
How do you configure a data project to run automatically on a recurring schedule?
Select an answer first
3foundation · easy
What is the purpose of enabling change tracking for a data entity in Dynamics 365 Finance and Operations?
Select an answer first
4expert · hard
A data import job failed, and the support team needs to identify which records failed and why. They also need to re-import only the failed records without re-running the entire job. What should they do?
Select an answer first
5application · medium
A manufacturing company wants to export a summary of inventory balances by warehouse and item to an external reporting system. The report should show only aggregated quantities, not individual transactions. You need to create a data entity that provides this grouped data for export. What should you create?
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.