Microsoft Power Platform Solution Architect — Question 66

A customer plans to use Microsoft Power Platform integration capabilities to migrate its on-premises sales database to Microsoft Dataverse. The database has more than 10 years of sales data with complex table relationships. The data is used to generate real-time sales reports and predictive analytics.

The customer requires a data migration strategy that implements the following:

• ensures minimal downtime
• maintains data integrity
• allows for validation of migrated data before switching to the new system
• ensures that the historical data is preserved accurately in the Dataverse environment

Which two strategies should you use? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Answer options

• A. Perform a full migration and start using Dataverse after migration.
• B. Perform a full migration and perform a test run on Dataverse to simulate real-time activity.
• C. Develop a phased migration plan in which data is moved in chunks based on years.
• D. Map the data schema to Dataverse and validate integrity through trial loads.
• E. Migrate historical data to Azure Data Lake to reduce migration complexity.

Correct answer: C, D

Explanation

The correct answers are C and D. A phased migration plan (C) allows for moving data in manageable chunks, which minimizes downtime and helps maintain data integrity. Mapping the data schema to Dataverse and validating through trial loads (D) ensures that the integrity of the data is checked before finalizing the migration. Options A and B risk downtime and do not provide a systematic approach to validate data. Option E, while reducing complexity, does not address the requirements for maintaining data integrity and validation within Dataverse.