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