MENU
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.
What should you recommend?
Suggested Answer: B
Get Premium AZ-305 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
ZI
Zita
5 days ago
Option A could work, but VMs need more maintenance.
AL
Alishia
10 days ago
I agree, B minimizes admin work too. Easy to manage!
BE
Bettye
15 days ago
I think option B is the best choice. Managed instance is perfect for transactions.
KE
Kenia
20 days ago
I’d go with B too, seems like the most efficient option!
RE
Reita
26 days ago
Wait, can we really do transactions across different databases in an elastic pool?
MA
Matthew
1 month ago
A might work, but managing VMs can be a hassle.
RO
Roxanne
1 month ago
Totally agree, managed instances are great for minimizing admin work!
AL
Alpha
1 month ago
I think B is the best choice for server-side transactions.
MI
Milly
2 months ago
I’m a bit confused about the differences between options A and B. I know A involves a VM, but does that really minimize admin effort?
CE
Celestine
2 months ago
I practiced a similar question, and I feel like having both databases on the same Azure SQL managed instance is the way to go for transaction support.
LA
Lashonda
2 months ago
I'm not entirely sure, but I remember something about elastic pools being useful for cost management. Would that apply here?
LE
Leontine
2 months ago
I think option B could be the best choice since it allows for server-side transactions and minimizes management overhead.