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?

A. two Azure SQL databases in an elastic pool

B. two databases on the same Azure SQL managed instance

C. two databases on the same SQL Server instance on an Azure virtual machine

D. two Azure SQL databases on different Azure SQL Database servers








 

Suggested Answer: B

Elastic database transactions for Azure SQL Database and Azure SQL Managed Instance allow you to run transactions that span several databases.
SQL Managed Instance enables system administrators to spend less time on administrative tasks because the service either performs them for you or greatly simplifies those tasks.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview?view=azuresql

This question is in AZ-305 Exam
For getting Azure Solutions Architect Expert Certificate