AZ-305 Question #220: Real Exam Question with Answer & Explanation

Question

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. Your company currently has an application that is hosted on their on-premises environment. The application currently connects to two databases in the on-premises environment. The databases are named whizlabdb1 and whizlabdb2. You have to move the databases onto Azure. The databases have to support server-side transactions across both of the databases. Solution: You decide to deploy the databases to an Azure SQL database-managed instance. Would this fulfill the requirement?

Options

• AYes
• BNo

Explanation

Moving two on-premises databases to Azure can maintain support for server-side transactions across both databases if an appropriate Azure SQL offering, such as Azure SQL Managed Instance, is utilized.

Common mistakes.

• B. Not applicable, as a solution exists that meets the requirements.

Concept tested. Azure SQL Distributed Transactions (MSDTC)

Reference. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/distributed-transactions-overview?view=azuresql

No community discussion yet for this question.