Provisioning SQL Databases — Question 66

You plan to create an AlwaysOn availability group that will have two replicas in Microsoft Azure and two on-premises replicas.
You need to configure the network to support the availability group listener.
Which cmdlet should you run first?

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, because a load balancer is essential for managing traffic to the availability group listener across replicas. The other options do not pertain to configuring a load balancer, which is crucial for enabling connectivity and failover for the AlwaysOn availability group.