You have an on-premises MySQL database that is 800 GB in size. You need to migrate a MySQL database to Azure Database for MySQL. You must minimize service interruption to live sites or applications that use the database. What should you recommend?
Suggested Answer:A🗳️
You can perform MySQL migrations to Azure Database for MySQL with minimal downtime by using the newly introduced continuous sync capability for the Azure Database Migration Service (DMS). This functionality limits the amount of downtime that is incurred by the application. Reference: https://docs.microsoft.com/en-us/azure/mysql/howto-migrate-online
Answer is correct.
Azure DMS performs an initial load of your on-premises to Azure Database for MySQL, and then continuously syncs any new transactions to Azure while the application remains running. After the data catches up on the target Azure side, you stop the application for a brief moment (minimum downtime), wait for the last batch of data (from the time you stop the application until the application is effectively unavailable to take any new traffic) to catch up in the target, and then update your connection string to point to Azure. When you are finished, your application will be live on Azure!
not obviously wrong! You can migrate db with dump/restore. But this is not cover the minimum downtime... so ANSWER IS CORRECT
upvoted 2 times
...
...
This section is not available anymore. Please use the main Exam Page.DP-201 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Wendy_DK
Highly Voted 3 years, 11 months agosyu31svc
Most Recent 4 years, 4 months agomemo43
3 years, 11 months ago