You have an on-premises Microsoft SQL Server 2022 instance named SQL1. You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1. You need to configure a bidirectional disaster recovery solution between SQL1 and SQLMH. What should you include in the solution?
Suggested Answer: B
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
AM
Amber
1 month ago
I'm leaning towards A) Log Replay Service. It’s crucial for disaster recovery scenarios.
RA
Raul
2 months ago
I agree, but B) the Managed Instance link could also work. It connects both instances.
GL
Glendora
2 months ago
I think D) a failover group is the best choice. It supports bidirectional replication.
DO
Dorothy
2 months ago
Azure Database Migration Service? Not sure that fits the bill.
EL
Elke
2 months ago
I agree, failover groups are key for bidirectional setups.
DA
Daryl
2 months ago
Wait, is LRS even applicable for this setup?
HO
Hoa
2 months ago
A failover group sounds like the best option here.
AN
An
3 months ago
Definitely need the Managed Instance link for that!
CH
Cherrie
3 months ago
I feel like Azure Database Migration Service is more for migrations rather than disaster recovery, but I could be wrong.
MA
Mattie
3 months ago
Log Replay Service sounds familiar, but I can't recall if it's specifically for bidirectional setups.
PA
Paris
3 months ago
I remember practicing a similar question about disaster recovery, and I think the Managed Instance link might be the right choice here.
LU
Lucy
3 months ago
I think we discussed failover groups in class, but I'm not entirely sure how they work with on-premises SQL Server.