You plan to deploy a highly available Microsoft SQL Server solution in Microsoft Azure to two virtual machines. Each virtual machine contains an OS disk and four data disks. You plan to configure both virtual machines to share a single public IP address. You need to recommend a highly availability solution to ensure that all the databases are available if a single server fails. What should you recommend including in the solution?

Question

Accepted Answer

C. Always On availability groups Always On availability groups provide high availability for a set of user databases, offering automatic failover and supporting a listener for client connections that can be configured with an Azure Load Balancer for a shared public IP. This ensures database availability across multiple independent SQL Server instances if a single server fails.

Answer

A. log shipping Log shipping is a disaster recovery solution that sends transaction log backups periodically and does not provide automatic failover for high availability.

Answer

B. Always On Failover Cluster Instances Always On Failover Cluster Instances (FCIs) require shared storage, which is not implied by the description of local data disks, and provide instance-level rather than database-level high availability.

Answer

D. database mirroring Database mirroring is a deprecated feature for high availability of a single database, superseded by Always On availability groups, and does not scale well for multiple databases.

You plan to deploy a highly available Microsoft SQL Server solution in Microsoft Azure to two virtual machines. Each virtual machine contains an OS disk and four data disks. You plan to configure both

Question

Options

How the community answered

Why each option

Topics

Community Discussion