Provisioning SQL Databases — Question 42

You plan to create an AlwaysOn availability group that will have two replicas in Microsoft Azure and two on-premises replicas.
You need to ensure that a replica in Azure is always available.
Which cmdlet should you run before you deploy the virtual machines?

Answer options

• A. New-AzureRmAvailabilitySet
• B. New-AzureRmLoadBalancer
• C. New-AzureRmSqlDatabaseSecondary
• D. New-AzureRmSqlElasticPool
• E. New-AzureRmVM
• F. New-AzureRmSqlServer
• G. New-AzureRmSqlDatabaseCopy
• H. New-AzureRmSqlServerCommunicationLink

Correct answer: B

Explanation

The correct answer is B, New-AzureRmLoadBalancer, as it is essential for distributing network traffic to the Azure replicas, ensuring they remain available. The other options, while related to Azure infrastructure, do not directly address the need for maintaining availability and load balancing for the replicas in the context of an AlwaysOn availability group.