Does the solution meet the goal?

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 use ASP.NET Core MVC with ADO.NET to develop an application. You implement database sharding for the application by using Azure SQL Database. You establish communication links between the shard databases.

You need to implement a strategy that allows a group of operations that are performed on multiple Azure databases to be rolled back on all databases if any of the operations fail.

Solution:

• Deploy a SQL database instance in an Azure Virtual Machine (VM).

• Establish linked servers to each Azure SQL Database instance from the SQL Server instance in the VM.

• Create a stored procedure in the VM that performs the update operations using a distributed transaction and commits them if successful.

• Run the SQL stored procedure on the SQL Server instance in the VM.

Does the solution meet the goal?
A . Yes
B . No

View Answer

Answer: B