It should be "B. Use SQL Server transactional replication"
Question said:
To avoid disrupting customer access, database downtime must be minimized when databases are migrated.
https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-to-database-from-sql-server
This doc supports "B. Use SQL Server transactional replication"
Correct answer should be B :- https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-to-database-from-sql-server .................as long as we agreed to use Azure Sql DB and with minimum down time migration it will lead to use SQL server transactional replication
From https://datamigration.microsoft.com/scenario/sql-to-azuresqldb?step=1.
"The following data migration options are discussed:
• Azure Database Migration Service (DMS)
• Data Migration Assistant (DMA)
• Transactional replication
• Bulk load"
From these, only transactional replication appears in the answers.
On top, C and D are incorrect because they talk about migrating to BLOB! which is incorrect. Technically, I believe that it would be possible to replicate using Site Recovery but the requirements tell us to use PaaS as much as possible.
B: backpac of course works but step2 can be repeated multiple times thus leading to longer downtime. Microsoft states to use Transactional for the best minimal downtime.
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.
considering the point minimized downtime, I would simply user ASR to replicate SQL VM to Azure. this can instantly switch on prem SQL onto Cloud with very little downtime. My bet will be on A
I recommend "D. Copy the BACPAC file that contains the Azure SQL database files to Azure Blob storage", but not "B. Use SQL Server transaction replication", because real-time is not required, just minimized.
If your client said minimal downtime and found out you chose an option that took the service down when other options offered zero downtime, you can expect an unhappy client. Zero downtime is the minimal downtime possible here.
upvoted 2 times
...
...
This section is not available anymore. Please use the main Exam Page.AZ-301 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.
Karls
Highly Voted 5 years, 4 months agotartar
4 years, 7 months agohighC
Highly Voted 4 years, 11 months agosallymaher
Most Recent 4 years, 1 month agosanketshah
4 years, 3 months agojohndadas
4 years, 4 months agodathwerth
4 years, 7 months agofemcold
4 years, 7 months agoimEmi
4 years, 7 months agoHarkonnen
4 years, 8 months agoMcrane86
4 years, 10 months agoMeasService
5 years agoRajuuu
4 years, 11 months agoDuke_YU
4 years, 10 months agoAvanade2023
5 years agoJakeCallham
4 years, 11 months agoTinyTrexArmz
4 years, 9 months ago