New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft AZ-305 Exam - Topic 10 Question 23 Discussion

Actual exam question for Microsoft's AZ-305 exam
Question #: 23
Topic #: 10
[All AZ-305 Questions]

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?

Show Suggested Answer Hide Answer
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


by Helga at Jun 22, 2022, 02:57 PM

Limited Time Offer

25%

Off

Get Premium AZ-305 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Mattie
4 months ago
I thought option A was a solid choice, but D makes more sense now.
upvoted 0 times
...
Anika
4 months ago
Wait, can we really do server-side transactions with option B? Seems off.
upvoted 0 times
...
Yolando
4 months ago
Definitely going with D, it minimizes admin effort as well.
upvoted 0 times
...
Keva
4 months ago
I think option C could work too, but not sure about the transactions.
upvoted 0 times
...
Onita
5 months ago
Option D is the best choice for server-side transactions!
upvoted 0 times
...
Leonida
5 months ago
I feel like option A could be too much administrative work since it involves a VM. I think we need something more streamlined.
upvoted 0 times
...
Peggie
5 months ago
I'm not entirely sure, but I remember something about elastic pools being useful for managing multiple databases. Could option C work?
upvoted 0 times
...
Rhea
5 months ago
I think option D might be the best choice since it mentions a managed instance, which should support server-side transactions.
upvoted 0 times
...
Tomoko
5 months ago
I recall that option B would separate the databases, which might complicate transactions. I lean towards option D for simplicity and support.
upvoted 0 times
...
Karan
5 months 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.
upvoted 0 times
...
Joesph
5 months 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.
upvoted 0 times
...
Denae
5 months ago
I think it might be perceived competition, but I'm not entirely sure if that's the only issue.
upvoted 0 times
...
Shonda
5 months ago
I think the answer is D. Contactless tokens form a logical connection to the client computer without a physical connection.
upvoted 0 times
...

Save Cancel