DP-300: Administering Relational Databases on Microsoft Azure
Microsoft DP-300 Exam
Administering Relational Databases on Microsoft Azure
Last Updated: Jul 2, 2024
311
311 Questions and Answers for the Microsoft DP-300 exam
485
Students Passed the "Microsoft DP-300" exam
94.3%
Average score during Real Exams at the Testing Centre
Microsoft Administering Relational Databases on Microsoft Azure Syllabus
Configure database authentication by using platform and database tools/ Deploy resources by using manual methods
Plan and Implement a High Availability and Disaster Recovery (HADR) Environment/ Apply patches and updates for hybrid and IaaS deployment
Evaluate the security aspects of the possible database offering/ Prepare an operational performance baseline
Recommend an appropriate database offering based on specific requirements/ Identify and implement index changes for queries
Recommend an HADR strategy for a data platform solution/ Evaluate the functional benefits/impact of possible database offerings
Manage schedules for regular maintenance jobs/ Deploy database offerings on selected platforms/ Plan and Implement Data Platform Resources
Configure database and object-level permissions using graphical tools/ Apply principle of least privilege for all securables
Determine the appropriate Dynamic Management Views (DMVs) to gather query performance information/ Evaluate the HA/DR of the possible database offering
Configure multi-server automation/ Configure customized deployment templates/ Evaluate the scalability of the possible database offering
Automate database maintenance tasks/ Configure database authorization by using platform and database tools
Extract query plans from the Query StoreEvaluate performance improvements/ Assess database performance by using Azure SQL Database Intelligent Performance
Recommend query construct modifications based on resource usage/ determine sources for performance metrics