Ans : C
There are two primary methods for migrating a SQL Server 2005 or later database to Azure SQL Database. The first method is simpler but requires some, possibly substantial, downtime during the migration. The second method is more complex, but substantially eliminates downtime during the migration.
Method 1: Migration with downtime during the migration
Method 2: Use Transactional Replication
Ref : https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-to-database-from-sql-server?view=azuresql#method-1-migration-with-downtime-during-the-migration
Transactional replication：
- Setup is relatively complex compared to other migration options.
- Provides a continuous replication option to migrate data (without taking the databases offline).
- Transactional replication has limitations to consider when you're setting up the publisher on the source SQL Server instance. See Limitations on publishing objects to learn more.
- It's possible to monitor replication activity.
D is correct. Because the question is minimize the downtime. Rather than using DMA, you can also use a BACPAC file. See Import a BACPAC file to a new database in Azure SQL Database.
Use Transactional Replication will be no down time.
)))
It is worth mentioning explicitly that the amount of downtime required to create, upload, and import a bacpac of a large database may be prohibitively large in the context of an actual production application migration. In those cases, the migration approach using transactional replication, which significantly reduces the necessary downtime at the cost of added complexity, may be a feasible solution.
I agree with you. I think the quetion is too tricky and confusing.
upvoted 1 times
...
...
...
This section is not available anymore. Please use the main Exam Page.DP-300 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.
LanPlanche
Highly Voted 2 years, 5 months agoscottytohotty
Most Recent 5 months agoorionduo
1 year, 4 months agoNew_Azure_User
2 years, 3 months agoItsalwaymethecap
2 years, 3 months agoeric0718
2 years, 6 months agofreemun05
2 years, 6 months agoeric0718
2 years, 6 months ago