DP-300 · Question #263
You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL database named SQLDB1. You need to replicate DB1…
The correct answer is A. transactional. To replicate an on-premises SQL Server database to an Azure SQL Database for continuous data synchronization, transactional replication is the most suitable method.
Question
Options
- Atransactional
- Bpeer-to-peer
- Csnapshot
- Dmerge
How the community answered
(25 responses)- A84% (21)
- B8% (2)
- C4% (1)
- D4% (1)
Why each option
To replicate an on-premises SQL Server database to an Azure SQL Database for continuous data synchronization, transactional replication is the most suitable method.
Transactional replication allows an on-premises SQL Server instance to act as a publisher and an Azure SQL Database to function as a subscriber. This configuration facilitates continuous, near real-time synchronization of data changes from the on-premises database to the Azure SQL Database.
Peer-to-peer replication is a specific topology for transactional replication among multiple publishing servers, not for replicating from a single on-premises SQL Server to an Azure SQL Database subscriber.
Snapshot replication applies a full copy of the data at intervals, which provides higher latency and is less efficient than transactional replication for ongoing, continuous data synchronization.
Merge replication is not supported by Azure SQL Database, making it an incompatible option for replicating to this Azure service.
Concept tested: SQL Server transactional replication to Azure SQL Database
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database
Topics
Community Discussion
No community discussion yet for this question.