DP-300: Administering Microsoft Azure SQL Solutions Exam

Microsoft DP-300 course, also known as "Administering Relational Databases on Microsoft Azure," is a certification course that teaches students how to administer and manage relational databases on the Microsoft Azure platform. This course is designed to provide students with the knowledge and skills necessary to manage and maintain databases in Azure, as well as prepare for the DP-300 certification exam.Candidates for this exam should have knowledge of and experience with Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines (Windows and Linux).Plan and implement data platform resources (20–25%)Implement a secure environment (15–20%)Monitor, configure, and optimize database resources (20–25%)Configure and manage automation of tasks (15–20%)Plan and configure a high availability and disaster recovery (HA/DR) environment (20–25%)Plan and implement data platform resources (20–25%)Plan and deploy Azure SQL solutionsDeploy database offerings on selected platformsUnderstand automated deploymentApply patches and updates for hybrid and infrastructure as a service (IaaS) deploymentDeploy hybrid SQL Server solutionsRecommend an appropriate database offering based on specific requirementsEvaluate the security aspects of the possible database offeringRecommend a table partitioning solutionRecommend a database sharding solutionConfigure resources for scale and performanceConfigure Azure SQL Database for scale and performanceConfigure Azure SQL Managed Instance for scale and performanceConfigure SQL Server on Azure Virtual Machines for scale and performanceConfigure table partitioningConfigure data compression