Azure Database Administrator Associate (DP-300) Cert Prep: 3 High Availability and Disaster Recovery in Azure Data Services
1h 7mIntermediate2021-12-03
Authors
Adam Wilbert
Data Visualization Expert
Course details
Passing the Microsoft DP-300 certification exam allows job seekers to demonstrate proficiency with next-gen, cloud-based database technologies, and in this Administering Relational Databases on Microsoft Azure (DP-300) Cert Prep series of courses, Adam Wilbert takes you through the key aspects of the exam that you need to know. This third and final course in the series highlights the high availability features of Azure, as and shows how to protect your databases with automated backups.
Skills covered
SQL ServerDatabase AdministrationIncident ResponseDatabase ManagementAzureNetwork AdministrationCloud PlatformsCert PrepCybersecurityNetwork and System AdministrationCloud ComputingMicrosoft
Concepts
Introduction
- Protect your databases on Azure
- What you should know
Avoiding Server Downtime
- Recovery time and recovery point objectives
- High availability options for virtual machines
- Extend high availability across the Azure platform
- High availability for Azure SQL Database
- Auto-failover groups
Windows Server Failover Cluster
- What is a WSFC
- Determining quorum in a failover cluster
- Create a failover cluster in Azure
- Test the cluster
Always On Availability Groups
- What is an Always On availability group
- Prepare the SQL Server nodes
- Grant authority to the system user account
- Create an availability group
Back Up and Restore a Database
- Back up an Azure virtual machine
- Back up a database on Azure
- Review the Recovery Services vault
- Back up PaaS databases
Conclusion
- Next steps