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
Creating the listener should in my opinion be the last step. See also exam ref page 311.
2
1
it’s No. 4
before Data Sync and network path
1
0
Both way work: You can create listener as final step or before synchronizing the replica. It must surely be configured after the AG creation. Therefore both Kaspar and KTF are right.
Question is what exam thinks is right? I would go with Listener at the end as this is how the exam ref goes!
1
0
I would go with:
Launch failover cluster manager
Enable SQL 2016 Always On feature
Create Always On AG and select DBs
Add and configure replica and listener
Select full data sync and specify network path
3
0
I agree…
Launch failover cluster manager
Enable SQL 2016 Always On feature
Create Always On AG and select DBs
Add and configure replica and listener
Select full data sync and specify network path
3
0