← Microsoft Certified: Azure Database Administrator Associate
AZURE · objective · 22% of the exam
Plan and configure a high availability and disaster recovery (HA/DR) environment — Microsoft Certified: Azure Database Administrator Associate
The official AZURE documentation our Plan and configure a high availability and disaster recovery (HA/DR) environment practice questions are cited to. Review the primary sources, then practise.
Official references for this objective
-
Microsoft — Use Distributed AG to Migrate Availability Group - SQL Server on Azure VMs | Microsoft Learn
This article is intended for databases participating in an availability group, and requires a Windows Server Failover Cluster (WSFC) and an availability group listener.
-
This solution doesn't require a Windows Server Failover Cluster (WSFC) or an availability group listener.
-
Microsoft — Migrate Availability Group - SQL Server on Azure VMs | Microsoft Learn
For the SQL clustered resource, use the same value for service port as the probe port in the CSV. For other cluster roles, the default
-
Microsoft — Business Continuity with Azure - Disaster Recovery | Microsoft Learn
Azure Site Recovery can replicate your workloads from the primary site (on prem or in Azure) to a secondary location.
-
Microsoft — Complete Migration Using a Distributed Availability Group - SQL Server on Azure VMs | Microsoft Learn
If your domain controller is on the source side, validate that your target SQL Server VMs in Azure are joined to the domain before abandoning
-
Microsoft — Prerequisites: Migrate to SQL Server VM Using Distributed AG - SQL Server on Azure VMs | Microsoft Learn
configure a Site-to-site VPN connection or an Azure ExpressRoute connection between the on-premises network and the virtual network where your target SQL Server VM resides