Welcome to this course for DP-300 Administering Relational Databases on MS Azure Tests
DP-300 Exam Database Administrator manages and implements the operational aspects of cloud-native and hybrid data platform solutions built on Microsoft Azure data services and Microsoft SQL Server. The Azure Database Administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.
As per DP-300 Exam Syllabus included topics :
Plan and implement data platform resources (15-20%)
Deploy resources by using manual methods
Recommend an appropriate database offering based on specific requirements
Configure resources for scale and performance
Evaluate a strategy for moving to Azure
Implement a migration or upgrade strategy for moving to Azure
Implement a secure environment (15-20%)
Configure database authentication by using platform and database tools
Configure database authorization by using platform and database tools
Implement security for data at rest
Implement security for data in transit
Implement compliance controls for sensitive data
Monitor and optimize operational resources (15-20%)
Monitor activity and performance
Implement performance-related maintenance tasks
Identify performance-related issues
Configure resources for optimal performance
Configure a user database for optimal performance
Optimize query performance (5-10%)
Perform automation of tasks (10-15%)
Plan and implement a High Availability and Disaster Recovery (HADR) environment (15-20%)
Recommend an HADR strategy for a data platform solution
Test an HADR strategy by using platform, OS and database tools
Perform backup and restore a database by using database tools
Configure HA/DR by using OS, platform and database tools
Perform administration by using T-SQL (10-15%)
Examine system health
Monitor database configuration by using T-SQL
Perform backup and restore a database by using T-SQL
Manage authentication by using T-SQL
Manage authorization by using T-SQL
