Microsoft Azure Architect Design (2020, legacy) — Question 7

You have an app named App1 that uses two on-premises Microsoft SQL Server databases named DB1 and DB2.
You plan to migrate DB1 and DB2 to Azure.
You need to recommend an Azure solution to host DB1 and DB2. The solution must meet the following requirements:
✑ Support server-side transactions across DB1 and DB2.
✑ Minimize administrative effort to update the solution.
What should you recommend?

Answer options

• A. two Azure SQL databases in an elastic pool
• B. two Azure SQL databases on different Azure SQL Database servers
• C. two Azure SQL databases on the same Azure SQL Database managed instance
• D. two SQL Server databases on an Azure virtual machine

Correct answer: C

Explanation

The correct answer is C because hosting both databases on the same Azure SQL Database managed instance allows for server-side transaction support and simplifies management tasks. Options A and B do not support server-side transactions between the databases, and option D involves more administrative overhead due to managing a virtual machine.