AZ-305 · Question #139
AZ-305 Question #139: Real Exam Question with Answer & Explanation
The correct answer is D: two databases on the same Azure SQL managed instance. 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 Insta
Question
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?
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
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
Community Discussion
No community discussion yet for this question.