BenchMark Quizzes by MDFT Pro

Select Replication Type For On-Premises To Azure SQL Database

You work for MDFT Pro, a well-known training agency with an on-premises Microsoft SQL Server 2019 instance hosting a database named CourseContent. Mark, the Database Replication Engineer, has an Azure subscription containing an Azure SQL database named CloudCourseContent. The CourseContent database contains course materials, training videos metadata, instructor guides, and student resources that are frequently updated by the curriculum development team working on-premises. Mark needs to replicate CourseContent to CloudCourseContent to support a cloud-based student portal that allows students worldwide to access course materials with low latency. He wants continuous one-way replication from the on-premises database to the cloud database to keep the cloud copy synchronized with the latest course updates.

Which type of replication should you use?

Choose the correct answer from the options below.

Explanations for each answer:

transactional is correct. Transactional replication supports one-way replication from on-premises SQL Server to Azure SQL Database, making it ideal for this scenario.
peer-to-peer is incorrect. Peer-to-peer replication is not supported with Azure SQL Database as it requires SQL Server Enterprise edition on all nodes.
snapshot is incorrect. While snapshot replication can work, it's not ideal for continuous replication as it completely refreshes data and doesn't provide ongoing synchronization.
merge is incorrect. Merge replication is not supported with Azure SQL Database as a subscriber.

Learn more about Replication To Azure SQL Database:

Replication To Azure SQL Database

Practice Exam

Select Replication Type For On-Premises To Azure SQL Database

Discuss this question on social media: