You have an application that currently uses two on-premises SQL Server databases (DB1 and DB2). You will migrate both databases to Azure. The solution must support server-side transactions that span DB1 and DB2 and minimize administrative effort for updates. Which hosting option should you recommend?
Choose an answer
Tap an option to check your answer.
Correct answer: Two databases on the same Azure SQL Managed Instance.
Why this is the answer
The correct option is "Two databases on the same Azure SQL Managed Instance" because Azure SQL Managed Instance supports distributed transactions (server-side transactions that span multiple databases) within the same instance, which is a key requirement for the application. It also offers a fully managed service, minimizing administrative effort compared to an Azure VM. "Two Azure SQL databases in an elastic pool" is incorrect because while elastic pools simplify management and cost for multiple databases, Azure SQL Database (even in an elastic pool) does not natively support distributed transactions between databases. "Two databases on the same SQL Server instance hosted on an Azure virtual machine" is incorrect because while it supports distributed transactions, it requires significant administrative effort for patching, backups, and high availability, which goes against the requirement to minimize administrative effort. "Two Azure SQL databases on different Azure SQL Database servers" is incorrect for the same reason as the elastic pool option: Azure SQL Database does not support distributed transactions between databases, especially across different servers.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed