DP-300: Administering Relational Databases on Microsoft Azure

About Microsoft Certified: Azure Database Administrator Associate

 

Exam Questions	Case study, short answer, repeated answer, MCQs
Number of Questions	140-160
Time to Complete	120 minutes
Exam Fee	165 USD

 

The Microsoft Certified: Database administrators and data management specialists who handle on-premises and cloud relational databases developed with SQL Server and Azure Data Services are candidates for this test.

The Azure Database Administrator is responsible for implementing and managing cloud native and hybrid data platform solutions based on Azure Data Services and SQL Server. To accomplish day-to-day operations, and Azure Database Administrator employs a range of methodologies and technologies, including the usage of T-SQL for administrative management.

This position is in charge of managing, securing, and optimizing modern relational database solutions in terms of availability, security, and performance. This role collaborates with the Azure Data Engineer role to manage operational elements of data platform solutions.

This exam measures your ability to accomplish the following technical tasks:

1. Plan and implement data platform resources (15-20%)
2. Implement a secure environment (15-20%)
3. Monitor and optimize operational resources (15-20%)
4. Optimize query performance (5-10%)
5. Perform automation of tasks (10-15%)
6. Plan and implement a High Availability and Disaster Recovery (HADR) environment (15-20%)
7. Perform administration by using T-SQL (10-15%)

 

Recommended Knowledge

1. Deploy resources by using manual methods
2. Recommend an appropriate database offering based on specific requirements
3. Configure resources for scale and performance
4. Evaluate a strategy for moving to Azure
5. Implement a migration or upgrade strategy for moving to Azure
6. Configure database authentication by using platform and database tools
7. Configure database authorization by using platform and database tools
8. Implement security for data at rest
9. Implement security for data in transit
10. Implement compliance controls for sensitive data
11. Monitor activity and performance
12. Implement performance-related maintenance tasks
13. Identify performance-related issues
14. Configure resources for optimal performance
15. Configure a user database for optimal performance
16. Review query plans
17. Evaluate performance improvements
18. Review database table and index design
19. Create scheduled tasks
20. Evaluate and implement an alert and notification strategy
21. Manage and automate tasks in Azure
22. Recommend an HADR strategy for a data platform solution
23. Test an HADR strategy by using platform, OS, and database tools
24. Perform backup and restore a database by using database tools
25. Configure HA/DR by using OS, platform, and database tools
26. Examine system health
27. Monitor database configuration by using T-SQL
28. Perform backup and restore a database by using T-SQL
29. Manage authentication by using T-SQL
30. Manage authorization by using T-SQL

 

All the required information is included in this certification course.

	Domain	Percentage
Domain 1	Plan and implement data platform resources	15-20%
Domain 2	Implement a secure environment	15-20%
Domain 3	Monitor and optimize operational resources	15-20%
Domain 4	Optimize query performance	5-10%
Domain 5	Perform automation of tasks	10-15%
Domain 6	Plan and implement a High Availability and Disaster Recovery (HADR) environment	15-20%
Domain 7	Perform administration by using T-SQL	10-15%