Question

You plan to deploy a SQL server instance to an Azure virtual machine and implement an Always On availability group that will contain databases hosted on both SQL server instances. What is the purpose of implementing an Always On availability group in this scenario?

1) To provide high availability and disaster recovery for the SQL server databases
2) To improve the performance of the SQL server instance
3) To enable automatic scaling of the SQL server resources
4) To simplify the management of the SQL server instances

Answer 1

The purpose of implementing an Always On availability group in this scenario is to provide high availability and disaster recovery for the SQL server databases.

Step-by-step explanation:

In this scenario, the purpose of implementing an Always On availability group is to provide high availability and disaster recovery for the SQL server databases. An Always On availability group is a feature in SQL Server that allows you to create a group of SQL Server instances that work together to provide high availability and failover support. It ensures that database services remain available even in the event of hardware failure, software failure, or network failure.