Home › Azure AZ-305 › cloudcomputing › az305continuity › Which Azure SQL Managed Instance HA tier should …
Which Azure SQL Managed Instance HA tier should an architect recommend for the highest in-region availability with multiple replicas and automatic failover?
ASingle-zone deployment
BGeneral Purpose without zone redundancy
CAzure DNS failover
DBusiness Critical service tier (with availability-zone-aware Always On AG-style replicas)
Answer & Solution
Correct answer: D. Business Critical service tier (with availability-zone-aware Always On AG-style replicas)
Business Critical tier provides in-region HA via Always-On replicas (per AZ-305 §3 SQL HA). The others have lower HA guarantees.
Related questions
Which Azure backup feature should an architect recommend for a workload requiring cross-reWhich Azure VM Scale Set feature should an architect recommend to automatically scale capaWhich Azure service should an architect recommend to keep a stretched-MS-SQL HA solution aWhich Azure load balancer should an architect recommend for global HTTP(S) traffic distribWhich Azure storage feature should an architect recommend to protect Azure Blob Storage daWhich Cosmos DB feature should an architect recommend to provide active-active multi-regioWhich Azure storage redundancy option should an architect recommend for data that must surWhich Azure VM construct should an architect recommend to deploy two or more VMs in the SA