DP-300 Certification Practice Question #46

Question

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 to SQLDB1.

Which type of replication should you use?

Accepted Answer

Microsoft Learn explicitly states that Azure SQL Database can serve as a push subscriber only in snapshot or one-way transactional replication topologies. Since the question asks to **replicate** (implying continuous, ongoing replication rather than a one-time snapshot copy), transactional replication is the correct and best fit. Peer-to-peer and merge replication are not supported for Azure SQL Database as a subscriber, eliminating B and D. While C (snapshot) is technically supported, it is inferior to transactional for ongoing replication as it does not deliver incremental changes in near-real time.

More DP-300 practice questions