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 reco...
Microsoft AZ-305 Exam
Questions Number: 81 out of 268 Questions
30.22%
Question 81
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?
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
