Microsoft Azure Architect Technologies (2020, legacy) — Question 45

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an app named App1 that uses data from two on-premises Microsoft SQL Server databases named DB1 and DB2.
You plan to move DB1 and DB2 to Azure.
You need to implement Azure services to host DB1 and DB2. The solution must support server-side transactions across DB1 and DB2.
Solution: You deploy DB1 and DB2 as Azure SQL databases on the same Azure SQL Database server.
Does this meet the goal?

Answer options

Correct answer: B

Explanation

The correct answer is B because deploying DB1 and DB2 as Azure SQL databases on the same server does not support server-side transactions across the databases. Azure SQL Database supports transactions only within a single database, not across multiple databases. Therefore, a different approach is necessary to achieve the goal of supporting server-side transactions between DB1 and DB2.