DP-300: Azure Database Administrator Associate

DP-300: Azure Database Administrator Associate

• Module: Plan and Implement Data Platform Resources (20–25%)
  • Provision Azure SQL Database, Azure SQL Managed Instance, and SQL Server VMs
  • Design for scalability, performance, and migration strategies
• Module: Implement a Secure Environment (15–20%)
  • Configure authentication, authorization, and encryption (e.g., TDE, AAD)
  • Set up auditing, compliance, and secure configurations
• Module: Monitor, Configure, and Optimize Database Resources (20–25%)
  • Monitor performance, resource utilization, and database metrics
  • Optimize query performance and configure alerts/monitoring tools
• Module: Configure and Manage Automation of Tasks (15–20%)
  • Automate routine tasks (backups, patching, indexing) via PowerShell or Azure Automation
  • Schedule database maintenance and use IaC where applicable
• Module: Plan and Configure High Availability and Disaster Recovery (HA/DR) (20–25%)
  • Implement replication, failover groups, and geo-redundancy
  • Design solutions for backup, restore, and business continuity
• Optional Module: Perform Administration Using T-SQL (10–15%)
  • Execute T-SQL for database administration tasks (backup, consistency checks, etc.)