DRAG DROP
You administer two servers AO-AG2 and ao-ag2. Microsoft SQL Server 2016 Enterprise Edition is running on both servers.
You need to configure a new Microsoft SQL Server Always On Availability Group.
Which three actions should you perform? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
Step 1: Create a Windows Server Failover Clustering (WSFC) cluster with AO-AG1 and AO-AG2 as nodes.
Since AlwaysOn Availability Groups require a Windows Server Failover Cluster, we first need to add the Windows Failover Cluster Feature to all the machines running the SQL Server instances that we will configure as replicas.
Step 2: Configure a secondary replica In the Specify Replicas page, under the Replicas tab, click the Add Replicas button and connect to the other SQL Server instances that you joined as nodes in your Windows Server Failover Cluster.
Step 3: Create an Always On Availability Group and select the availability databases Once the Windows Server Failover Cluster has been created, we can now proceed with enabling the AlwaysOn Availability Groups feature in SQL Server 2012. This needs to be done on all of the SQL Server instances that you will configure as replicas in your Availability Group.