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…

Question

Options

• Atwo databases on the same SQL Server instance on an Azure virtual machine
• Btwo Azure SQL databases on different Azure SQL Database servers
• Ctwo Azure SQL databases in an elastic pool
• Dtwo databases on the same Azure SQL managed instance

• A
  12% (5)
• B
  21% (9)
• C
  5% (2)
• D
  62% (26)

Explanation

When both the database management system and client are under the same ownership (e.g. when SQL Server is deployed to a 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. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions- overview?view=azuresql-azure

No community discussion yet for this question.