6-Plan and implement a High Availability and Disaster Recovery (HADR) environment (15-20%).md

DP-300: Plan and Implement a High Availability and Disaster Recovery (HADR) Environment (15-20%)

Recommend an HADR strategy for a data platform solution

• Recommend HADR strategy based on RPO/RTO requirements
  • Overview of business continuity with Azure SQL Database
• Evaluate HADR for hybrid deployments
• Evaluate Azure-specific HADR solutions
  • Azure-only: Disaster recovery solutions
• Identify resources for HADR solutions
  • Always On availability groups: a high-availability and disaster-recovery solution
  • Always On Failover Cluster Instances (SQL Server)
  • Log Shipping (SQL Server)

Test an HADR strategy by using platform, OS and database tools

• Test HA by using failover
  • Perform a planned manual failover of an Always On availability group (SQL Server)
• Test DR by using failover or restore

Perform backup and restore a database by using database tools

• Perform a database Backup with options
  • Create a Full Database Backup
• Perform a database Restore with options
• Perform a database Restore to a point in time
  • Azure SQL Database Point in Time Restore
• Configure long-term Backup retention
  • Manage Azure SQL Database long-term backup retention

Configure DR by using platform and database tools

• Configure replication
  • Tutorial: Prepare SQL Server for replication (publisher, distributor, subscriber)
• Configure Azure Site Recovery for a database offering

Configure HA using platform, OS and database tools

• Create an Availability Group
  • Tutorial: Configure availability group on Azure SQL Server VM manually
• Integrate a database into an Availability Group
• Configure Quorum options for a Windows Server Failover Cluster
  • WSFC Quorum Modes and Voting Configuration (SQL Server)
• Configure an Availability Group Listener

Return to Table of Contents