Design and implement Database Solutions for Microsoft SQL Server and Microsoft Azure SQL Database (20-25%)

Design a hybrid SQL Server solution

• Design a Disaster Recovery topology for a hybrid deployment, design a data storage architecture, design a security architecture, design a data load strategy, design a data synchronisation strategy

Implement SQL Server on Azure Virtual Machines (VMs)

• Provision SQL Server on an Azure VM, configure firewall rules, configure and optimise storage, migrate an on-premises database to Microsoft Azure, configure and optimise VM sizes by workload

Design a database solution on Azure SQL database and SQL Server in Azure

• Design a solution architecture, design a Geo/DR topology, design a security architecture, design a data load strategy, determine the appropriate service tier, determine the appropriate deployment scenario, determine IaaS vs PaaS, determine application access in Azure

Implement Azure SQL Database

• Provision Azure SQL Database, configure firewall rules, configure Active Geo-Replication, migrate an on-premises database to SQL Database, configure for scale and performance

Design and implement MySQL and PostgreSQL database solutions in Azure

• Design security, design a data load strategy, determine the appropriate service tier, provision databases and servers, configure firewall rules, migrate to Azure, configure for scale and performance

Design and Implement Security (25–30%)

Design and implement SQL Server Database security

• Configure firewalls; manage logins, users, and roles; assign permissions; configure auditing; configure Transparent Database Encryption (TDE); configure row-level security; configure data encryption; configure data masking; configure Always Encrypted

Design and implement Azure SQL Database security

• Configure firewalls; manage logins, users, and roles; assign permissions; configure auditing; configure row-level security; configure data encryption; configure data masking; configure Always Encrypted, configure Automatic Threat Detection

Design for high availability, disaster recovery and Scalability (25–30%)

Design and implement high availability solutions

• Design a high-availability solution topology, design a high-availability solution for SQL on Azure VMs, implement high-availability solutions

Design and implement scalable solutions

• Design a scale-out solution, implement multi-master scenarios with database replication, implement elastic scale for Azure SQL Database

Design and implement Azure SQL Database data recovery

• Implement self-service restore, copy and export databases, implement long-term retention backups

Monitor and manage database implementations in Azure (25–30%)

Monitor and troubleshoot SQL Server VMs on Azure

• Monitor database and instance activity, monitor by using DMVs and DMFs, monitor performance and scalability

Monitor and troubleshoot SQL Database

• Monitor and troubleshoot SQL Database, monitor database activity, monitor by using DMVs and DMFs, monitor performance and scalability

Automate and manage database implementations on Azure

• Automate and manage SQL Server on Azure VMs, automate and manage Azure SQL Database, configure automation and runbooks