You need to create an availability group listener named…

DRAG DROP
You are configuring a new Microsoft SQL Server Always On Availability Group. You plan to configure a shared
network location at \\\\DATA-CI1\\SQL.
You need to create an availability group listener named AGL1 on port 1433.In which order should you perform the actions? To answer, move all actions from the list of actions to the
answer area and arrange them in the correct order.
Select and Place:

DRAG DROP
You are configuring a new Microsoft SQL Server Always On Availability Group. You plan to configure a shared
network location at \\\\DATA-CI1\\SQL.
You need to create an availability group listener named AGL1 on port 1433.In which order should you perform the actions? To answer, move all actions from the list of actions to the
answer area and arrange them in the correct order.
Select and Place:

Answer:

Explanation:
Step 1: Launch the Failover Cluster Manager and..
To support theAlways On availability groups feature, ensure that every computer that is to participate in one or
more availability groups meets requirements including:
* Ensure that each computer is a node in a WSFC (Windows Server Failover Clustering).
Step 2: Add andconfigure the replica and…
All the server instances that host availability replicas for an availability group must use the same SQL Server
collation.
Step 3: Enable the SQL Server 2016 Always On Availability Group feature.
Enable the Always On availability groups feature on each server instance that will host an availability replica for
any availability group. On a given computer, you can enable as many server instances for Always On availability
groups as your SQL Server installation supports.
Step 4: Create the Always On Availability Group and..
Using Transact-SQL to create or configure an availability group listener
Connect to the server instance that hosts the primary replica.
Use the LISTENER option of the CREATE AVAILABILITY GROUP statement or the ADD LISTENER option of
the ALTER AVAILABILITY GROUP statement.
Step 5: Select the Full data synchronization method and…
https://technet.microsoft.com/en-us/library/jj899851(v=sc.12).aspxhttps://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/create-or-configure-anavailability-group-listener-sql-server



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Caspar

Caspar

Creating the listener should in my opinion be the last step. See also exam ref page 311.

KTF

KTF

it’s No. 4
before Data Sync and network path