Episode

Preparing for DP-300: Monitor, configure, and optimize database resources (Part 3 of 5)

with Sara El Sayed

In this third exam prep episode for DP-300, Sara introduces you to Monitoring, configuring, and optimizing database resources.

Skills measured

This episode covers the third of five high-level topics in the skills measured. This third skills group will account for 20-25% of the questions you might encounter on the exam.

  • 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%)

Chapters

  • 00:05 - Introduction
  • 00:21 - Monitor, configure, and optimize database resources
  • 00:58 - 3.1 Monitor resource activity and performance
  • 04:10 - 3.2 Monitor and optimize query performance
  • 08:27 - 3.3 Configure database solutions for optimal performance
  • 12:06 - Recap

Next episode

Azure
Azure SQL Database