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
|