Chapter 3: Plan and implement data platform resources -Plan and deploy Azure SQL solutions-Apply patches and updates for hybrid and infrastructure as a service (IaaS) deployment
Chapter 5: Plan and implement data platform resources -Plan and deploy Azure SQL solutions-Recommend an appropriate database offering based on specific requirements
Chapter 6: Plan and implement data platform resources -Plan and deploy Azure SQL solutions-Evaluate the security aspects of the possible database offering
Chapter 9: Plan and implement data platform resources -Configure resources for scale and performance-Configure Azure SQL Database for scale and performance
Chapter 10: Plan and implement data platform resources -Configure resources for scale and performance-Configure Azure SQL Managed Instance for scale and performance
Chapter 11: Plan and implement data platform resources -Configure resources for scale and performance-Configure SQL Server on Azure Virtual Machines for scale and performance
Chapter 23: Plan and implement data platform resources -Plan and implement a migration strategy-Implement Azure SQL Managed Instance database copy and move
Chapter 24: Implement a secure environment-Configure database authentication and authorization-Configure authentication by using Active Directory and Microsoft Entra ID
Chapter 27: Implement a secure environment-Configure database authentication and authorization-Configure database and object-level permissions using graphical tools
Chapter 28: Implement a secure environment-Configure database authentication and authorization-Apply the principle of least privilege for all securables
Chapter 49: Monitor, configure, and optimize database resources-Monitor resource activity and performance-Configure and monitor activity and performance
Chapter 57: Monitor, configure, and optimize database resources-Monitor and optimize query performance-Identify and implement index changes for queries
Chapter 58: Monitor, configure, and optimize database resources-Monitor and optimize query performance-Recommend query construct modifications based on resource usage
Chapter 59: Monitor, configure, and optimize database resources-Monitor and optimize query performance-Assess the use of query hints for query performance
Chapter 66: Monitor, configure, and optimize database resources-Configure database solutions for optimal performance-Configure server settings for performance
Chapter 69: Monitor, configure, and optimize database resources-Configure database solutions for optimal performance-Configure compute and storage resources for scaling
Chapter 74: Configure and manage automation of tasks -Automate deployment of database resources-Automate deployment by using Azure Resource Manager (ARM) and Bicep templates
Chapter 79: Configure and manage automation of tasks -Create and manage database tasks in Azure-Create and configure database tasks by using automation
Chapter 82: Plan and configure a high availability and disaster recovery (HA/DR) environment -Recommend an HA/DR strategy for database solutions-Recommend HA/DR strategy based on Recovery Point Objective/Recovery Time Objective (RPO/RTO) requirements
Chapter 83: Plan and configure a high availability and disaster recovery (HA/DR) environment -Recommend an HA/DR strategy for database solutions-Evaluate HA/DR for hybrid deployments
Chapter 84: Plan and configure a high availability and disaster recovery (HA/DR) environment -Recommend an HA/DR strategy for database solutions-Evaluate Azure-specific HA/DR solutions
Chapter 85: Plan and configure a high availability and disaster recovery (HA/DR) environment -Recommend an HA/DR strategy for database solutions-Recommend a testing procedure for an HA/DR solution
Chapter 86: Plan and configure a high availability and disaster recovery (HA/DR) environment -Plan and perform backup and restore of a database-Recommend a database backup and restore strategy
Chapter 87: Plan and configure a high availability and disaster recovery (HA/DR) environment -Plan and perform backup and restore of a database-Perform a database backup by using database tools
Chapter 88: Plan and configure a high availability and disaster recovery (HA/DR) environment -Plan and perform backup and restore of a database-Perform a database restore by using database tools
Chapter 89: Plan and configure a high availability and disaster recovery (HA/DR) environment -Plan and perform backup and restore of a database-Perform a database restore to a point in time
Chapter 90: Plan and configure a high availability and disaster recovery (HA/DR) environment -Plan and perform backup and restore of a database-Configure long-term backup retention
Chapter 91: Plan and configure a high availability and disaster recovery (HA/DR) environment -Plan and perform backup and restore of a database-Backup and restore a database by using T-SQL
Chapter 92: Plan and configure a high availability and disaster recovery (HA/DR) environment -Plan and perform backup and restore of a database-Backup and restore to and from cloud storage
Chapter 93: Plan and configure a high availability and disaster recovery (HA/DR) environment -Configure HA/DR for database solutions-Configure active geo-replication
Chapter 94: Plan and configure a high availability and disaster recovery (HA/DR) environment -Configure HA/DR for database solutions-Configure an Always On availability group on Azure virtual machines
Chapter 95: Plan and configure a high availability and disaster recovery (HA/DR) environment -Configure HA/DR for database solutions-Configure failover groups
Chapter 96: Plan and configure a high availability and disaster recovery (HA/DR) environment -Configure HA/DR for database solutions-Configure quorum options for a Windows Server Failover Cluster
Chapter 97: Plan and configure a high availability and disaster recovery (HA/DR) environment -Configure HA/DR for database solutions-Configure Always On Failover Cluster Instances on Azure virtual machines
Chapter 99: Plan and configure a high availability and disaster recovery (HA/DR) environment -Configure HA/DR for database solutions-Monitor an HA/DR solution
Chapter 100: Plan and configure a high availability and disaster recovery (HA/DR) environment -Configure HA/DR for database solutions-Troubleshoot an HA/DR solution