SQL Server Certifications

Official Microsoft SQL Server certifications to validate your database administration skills

Azure Database Administrator Associate

Exam Details

  • Exam Code: DP-300
  • Cost: $165 USD
  • Duration: 120 minutes
  • Questions: 40-60 multiple choice and case studies
  • Passing Score: 700 (on a scale of 1000)

How to Take the Exam

  • Online proctored or test center
  • Register at Pearson VUE or Microsoft Learn
  • Preparation: Microsoft Learn modules
  • Valid for 1 year (requires renewal)

Detailed Syllabus

  • Deploy resources with Azure portal, CLI, and PowerShell
  • Configure server and database settings
  • Evaluate requirements for SQL Server on Azure VMs

  • Configure database authentication and authorization
  • Implement security for data at rest and in transit
  • Implement compliance controls for sensitive data

  • Monitor activity and performance
  • Implement performance-related maintenance tasks
  • Identify performance-related issues

  • Review query plans
  • Evaluate performance improvements
  • Recommend query construct modifications

  • Create scheduled tasks
  • Automate deployment of database resources
  • Create alerts and notifications

  • Recommend an HADR strategy
  • Test an HADR environment
  • Perform backup and restore

  • Administer databases and instances
  • Manage authentication and authorization
  • Implement encryption and auditing
Official Resources: Microsoft Certification Page | Pearson VUE Registration

Microsoft Certified: Azure Data Engineer Associate

Exam Details

  • Exam Code: DP-203
  • Cost: $165 USD
  • Duration: 180 minutes
  • Questions: 40-60 multiple choice and case studies
  • Passing Score: 700 (on a scale of 1000)

How to Take the Exam

  • Online proctored or test center
  • Register at Pearson VUE or Microsoft Learn
  • Preparation: Microsoft Learn modules
  • Valid for 1 year (requires renewal)

Detailed Syllabus

  • Design a data storage structure
  • Implement partition strategies
  • Design and implement the serving layer
  • Implement physical data storage structures

  • Ingest and transform data
  • Develop a batch processing solution
  • Develop a stream processing solution
  • Manage batches and pipelines

  • Design security for data policies and standards
  • Implement data security
  • Monitor data security

  • Monitor data storage and data processing
  • Optimize and troubleshoot data storage and processing
Official Resources: Microsoft Certification Page | Pearson VUE Registration

Related Database Resources