A company needs to export customer data to an external system. The external system requires a full snapshot every night and incremental updates every hour. You need to configure the data project to support both without duplicating the entity. What should you do?

Enable change tracking and use only incremental export.

Use an aggregate data entity for customers.

Use a composite data entity for customers.

Create two data projects: one for full export and one for incremental export using change tracking.

A company needs to export a report that shows total sales by customer and region. They have a data entity that provides this aggregated data, but the report is slow because the entity queries a large dataset. What should they do to improve performance?

Use a regular data entity and add a filter to reduce the dataset.

Use an aggregate data entity that is pre-aggregated and indexed for reporting.

Disable change tracking on the entity to speed up queries.

Use a composite data entity that includes all sales order details and group in Excel.

A company is setting up a data import project. The source file has a column 'FullName' that needs to be split into 'FirstName' and 'LastName' in the target entity. They also need to map a 'CountryCode' column to a 'Country' field that expects the country name. What is the best approach?

Use calculated fields in the field mapping to split 'FullName' and use a value mapping to convert 'CountryCode' to 'Country'.

Map 'FullName' directly to 'FirstName' and ignore 'LastName' and 'Country'.

Use a composite data entity that automatically splits the name and converts the country code.

Use an aggregate data entity to pre-process the data before import.

In the Data management workspace, where can you see the status of a data entity during an import job?

In the execution history of the data project

In the database transaction log

In Dynamics 365 Finance and Operations, what is the primary purpose of a data entity when used for import and export operations?

To store raw transactional data in a format optimized for high-volume OLTP processing

To generate physical database indexes that improve query performance

To enforce referential integrity constraints between related tables in the database

To provide a de-normalized, business-friendly view of data that can be reused across integration scenarios

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 6Objective 3

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

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 6–10

6expert · hard
A company needs to export customer data to an external system. The external system requires a full snapshot every night and incremental updates every hour. You need to configure the data project to support both without duplicating the entity. What should you do?
Select an answer first
7expert · hard
A company needs to export a report that shows total sales by customer and region. They have a data entity that provides this aggregated data, but the report is slow because the entity queries a large dataset. What should they do to improve performance?
Select an answer first
8expert · hard
A company is setting up a data import project. The source file has a column 'FullName' that needs to be split into 'FirstName' and 'LastName' in the target entity. They also need to map a 'CountryCode' column to a 'Country' field that expects the country name. What is the best approach?
Select an answer first
9foundation · easy
In the Data management workspace, where can you see the status of a data entity during an import job?
Select an answer first
10foundation · easy
In Dynamics 365 Finance and Operations, what is the primary purpose of a data entity when used for import and export operations?
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.