144k views
4 votes
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.

A) Azure SQL Managed Instance
B) SQL Server on Azure Virtual Machine
C) Azure SQL Database Single Database
D) Azure SQL Database Hyperscale

1 Answer

0 votes

Final answer:

The best option to deploy a SQL server instance to an Azure virtual machine and implement an always on availability group with multiple instances is SQL Server on Azure Virtual Machine. The correct answer is B.

Step-by-step explanation:

The subject of this question is Computers and Technology. The question is asking about the best way to deploy a SQL server instance to an Azure virtual machine and implement an always on availability group containing databases hosted on both SQL server instances. The options given are Azure SQL Managed Instance, SQL Server on Azure Virtual Machine, Azure SQL Database Single Database, and Azure SQL Database Hyperscale.

To implement an always on availability group with multiple SQL server instances, the best option would be SQL Server on Azure Virtual Machine. This option allows you to have more control over the SQL server instance and enables you to configure and manage the availability group according to your requirements.

To implement Always On Availability Groups, you should use SQL Server on Azure Virtual Machine or potentially Azure SQL Managed Instance, but not Azure SQL Database Single Database or Hyperscale.

The question pertains to deploying a SQL Server instance on an Azure Virtual Machine and setting up an Always On Availability Group. The correct deployment options that allow you to implement an Always On Availability Group are B) SQL Server on Azure Virtual Machine and potentially A) Azure SQL Managed Instance, depending on the exact requirements and configurations. Options C) Azure SQL Database Single Database and D) Azure SQL Database Hyperscale do not support Always On Availability Groups as they are a feature of SQL Server and not currently offered in Azure SQL Database offerings. Always On Availability Groups provide high availability and disaster recovery capabilities for SQL Server instances hosting databases that need to remain available in the event of failure.

User CamW
by
9.0k points