70-473 · Question #103
Your environment contains a Microsoft Azure virtual machine and an Azure SQL database. The virtual machine has Microsoft SQL Server installed and contains several applications. You need to recommend a
The correct answer is B. Implement transactional replication.. To migrate an application's database from SQL Server on an Azure VM to an Azure SQL Database with minimal downtime, transactional replication is the most suitable method.
Question
Options
- AImplement log shipping.
- BImplement transactional replication.
- CRestore a BACPAC of the database.
- DRestore a backup of the database.
How the community answered
(25 responses)- A12% (3)
- B76% (19)
- C8% (2)
- D4% (1)
Why each option
To migrate an application's database from SQL Server on an Azure VM to an Azure SQL Database with minimal downtime, transactional replication is the most suitable method.
Log shipping typically involves restoring transaction log backups, which can lead to significant downtime during the final synchronization and cutover phase, especially for an active online application.
Transactional replication enables continuous data synchronization from the source SQL Server database on the VM to the target Azure SQL Database. This allows the application to remain online on the source while the target database is being populated and kept up-to-date, minimizing downtime during the final cutover.
Concept tested: SQL Server to Azure SQL DB migration
Source: https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database-online-migration-ssms?view=azuresql
Topics
Community Discussion
No community discussion yet for this question.