Designing Microsoft Azure Infrastructure Solutions AZ-305 — Topic 4 Question 188

Question

You have an on-premises line-of-business (LOB) application that uses a Microsoft SQL Server instance as the backend. You plan to migrate the on-premises SQL Server instance to Azure virtual machines. You need to recommend a highly available SQL Server deployment that meets the following requirements: • Minimizes costs Minimizes failover time if a single server fails What should you include in the recommendation?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: an Always On availability group that has premium storage disks and a distributed network name (DNN) By spanning multiple Availability Zones / adding redundancy, this option provides the high availability and resilience required.

Designing Microsoft Azure Infrastructure Solutions AZ-305 — Question 188