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?

A. New-AzureRmAvailabilitySet

B. New-AzureRmLoadBalancer

C. New-AzureRmSqlDatabaseSecondary

D. New-AzureRmSqlElasticPool

E. New-AzureRmVM

F. New-AzureRmSqlServer

G. New-AzureRmSqlDatabaseCopy

H. New-AzureRmSqlServerCommunicationLink

Explanation:

An availability group listener is a virtual network name that clients connect to for database access. On Azure virtual machines, a load balancer holds the IP address for the listener. The load balancer routes traffic to the instance of SQL Server that is listening on the probe port. Usually, an availability group uses an internal load balancer.

References: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-ps-alwayson-int-listener