Discuss Microsoft AZ-305 Exam Topic 10 Question 23

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?

Atwo SQL Server databases on an Azure virtual machine

Btwo Azure SQL databases on different Azure SQL Database servers

Ctwo Azure SQL databases in an elastic pool

Dtwo Azure SQL databases on the same Azure SQL Database managed instance

Suggested Answer: A

When both the database management system and client are under the same ownership (e.g. when SQL Server is deployed to a virtual machine), transactions are available and the lock duration can be controlled. Reference: https://docs.particular.net/nservicebus/azure/understanding-transactionality-in-azure

Get Premium AZ-305 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

13 comments · newest first

Mattie 11 months ago

I thought option A was a solid choice, but D makes more sense now.

Anika 11 months ago

Wait, can we really do server-side transactions with option B? Seems off.

Yolando 12 months ago

Definitely going with D, it minimizes admin effort as well.

Keva 12 months ago

I think option C could work too, but not sure about the transactions.

Onita 1 year ago

Option D is the best choice for server-side transactions!

Leonida 1 year ago

I feel like option A could be too much administrative work since it involves a VM. I think we need something more streamlined.

Peggie 1 year ago

I'm not entirely sure, but I remember something about elastic pools being useful for managing multiple databases. Could option C work?

Rhea 1 year ago

I think option D might be the best choice since it mentions a managed instance, which should support server-side transactions.

Tomoko 1 year ago

I recall that option B would separate the databases, which might complicate transactions. I lean towards option D for simplicity and support.

Karan 1 year ago

Hmm, the question mentions a subquery in the VALUES clause, which seems a bit unusual. I'll need to double-check the SQL syntax for that.

Joesph 1 year ago

Hmm, I'm a bit confused on this one. I'll need to review the DataRaptor documentation again to make sure I understand the different parts and how they relate to the JSON output.

Denae 1 year ago

I think it might be perceived competition, but I'm not entirely sure if that's the only issue.

Shonda 1 year ago

I think the answer is D. Contactless tokens form a logical connection to the client computer without a physical connection.

Microsoft AZ-305 Exam - Topic 10 Question 23 Discussion