Exam 70-765 topic 3 question 95 discussion

Actual exam question from Microsoft's 70-765

Question #: 95
Topic #: 3

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

Show Suggested Answer

Suggested Answer: B 🗳️
Expalantion:
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

by STH at Sept. 8, 2019, 6:56 p.m.

Comments

Submit Cancel

DudeHere

5 years, 2 months ago

B is the best answer given the choices. Here is what should be listed: Powershell: New-SqlAvailabilityGroupListener AZ CLI: az sql vm group ag-listener create -n <listener name>

upvoted 2 times

jolsca

4 years, 9 months ago

Is correct B https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-listener-powershell-configure

upvoted 1 times

...

RohitM

5 years, 8 months ago

Below comment is wrong. Question is about network not secondary node.

upvoted 4 times

...

STH

5 years, 9 months ago

A Load balancer is not the purpose of the question. To install nodes for an Availability Groupe you need the to use the command New-AzureRmSqlDatabaseSecondary

upvoted 1 times

...