Migrating Legacy Data into Finance and Operations Apps
You need to implement the migration requirements. Which two options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Community Insight
The question tests whether you can distinguish inbound data-loading mechanisms from outbound analytics repositories, and the trap is choosing BYOD or Entity store because they are also built on data entities.
For loading legacy and vendor-supplied data into Dynamics 365 finance and operations apps, only data entity based inbound paths qualify: a public data entity used through the Excel add-in, and a data entity driven Data Management import job. BYOD and Entity store are outbound analytical stores, so they cannot satisfy a migration requirement.
The most common wrong pick is A (data entity and BYOD). Learners see that BYOD is built on data entities and assume it supports migration, but BYOD only exports entity data to an external SQL database for analytics, data warehousing and batch reporting integration, so nothing is loaded into the finance and operations database.
Community Discussion (9 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
A public data entity exposed through OData can be consumed by the Excel add-in, which lets an authorized user load or maintain records in finance and operations apps, and the same data entity can be staged and loaded through a Data Management import job for file- or package-based bulk migration. Together these two options are complete inbound solutions: one interactive and suited to smaller reference sets such as a vendor exclusion list, the other the supported high-volume path for full legacy data migration. Both use the standard data entity framework, which is the sanctioned mechanism for moving data into the application database.Why the Other Options Are Wrong
Bring your own database (BYOD) exports entity data from finance and operations to an external SQL data warehouse for reporting and analytics; it never writes data back, so it cannot implement a migration. Entity store is an embedded analytical data lake (a Data Lake-backed workspace of aggregated entities) used for Power BI and embedded reports, and like BYOD it is a read-only consumption repository for outbound data. Option C pairs a data entity with Entity store, and option A pairs a data entity with BYOD, so in both cases the second half disqualifies the pair even though the data entity half is valid. Community consensus is also relevant here but the reasoning above, not the vote, is what settles it.Community Comment Notes
Most voters converge on B and D, with phamvanphuong1501 simply labeling them as the options that "import into D365" and AbhiN1106 correctly noting that "BYOD and Entity store are outbound analytical export repositories only." javism1106 adds a practical caveat, saying "I would not recommend Excel (Odata) for migration purposes," which is sound production advice but does not change exam correctness since Excel still presents a complete solution. yuri_rusanov's phrasing that the scenario calls for a "(public) data entity for their legacy system, Excel add-in for their vendor exclusion list access" matches the option wording directly. One dissenter, sadoki9311, chose A and B, but that choice is inconsistent with BYOD being export-only.Official Reference
Exam Strategy
In MB-500 migration questions, immediately classify each mechanism as inbound (writes into the F&O database) or outbound (export/analytical). BYOD and Entity store are always outbound, so any option containing them is wrong for a migration requirement.
Frequently Asked Questions
Why is BYOD not a valid option for this migration requirement?
BYOD (bring your own database) exports data entity records to an external SQL database for analytics and warehousing. It is a one-way outbound path and never loads data back into finance and operations.
Can Entity store be used to migrate legacy data into Dynamics 365?
No. Entity store holds aggregated entity data in an analytical data lake for Power BI and embedded reports. It supports reporting consumption, not inbound data migration.
Is the Excel add-in really appropriate for migrating data?
On the exam it counts as a complete solution for smaller reference data exposed as a public data entity via OData. In production, prefer a Data Management import job for volume, but Excel is still a valid loading mechanism.
Related Analysis
Practice All MB-500 Questions
Access 115 questions with complete answers and detailed explanations.
View Full MB-500 Practice Test →