dc dotCreds
Flashcard notes

Microsoft DP-300 Study Guide

Preview the Microsoft DP-300 flashcard-note study format, then unlock Pro for the complete section-by-section guide.

Continue Course Course Notes Start Practice Study Guide PDF (Pro)
15 of 15 sections shown
Study Guide preview

Unlock Pro for every Microsoft DP-300 flashcard-note lesson.

Preview the beginning of Section 1. Pro includes the complete Study Guide by section, plus Course Notes, guided course access, and Pro downloads.

Unlock with Pro

Opens the Microsoft DP-300 Practice Test purchase options.

Section 1 Plan and deploy Azure SQL solutions Preview

Preview: Plan and implement data platform resources (15%-20%)

Preview includes
  • 4 of 8 lesson topics
  • 1 overview segment
  • 3 core concepts
  • 2 exam tips

Lesson Topics

  • Choose among Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs, and hybrid SQL
  • Select an automated deployment approach
  • Use Azure Arc-enabled SQL where centralized Azure management of hybrid SQL is required
  • Recognize use cases for SQL database in Microsoft Fabric

Overview

Deployment questions are requirement-matching exercises. Start with compatibility, OS/instance control, management overhead, scaling, HA/DR, networking, and migration constraints before choosing a platform.

Core Concepts

  • Azure SQL Database is a fully managed PaaS database service and is usually preferred when applications can use database-level scope and do not require full SQL Server instance or OS control.
  • Azure SQL Managed Instance provides a managed instance with broad SQL Server compatibility and instance-scoped capabilities, useful for migrations that need more SQL Server feature compatibility than single Azure SQL Database.
  • SQL Server on Azure VMs provides OS and SQL Server instance control but leaves substantially more patching, backup, HA, security, and infrastructure administration with the customer.

Exam Tips

  • Write down the hard requirement before picking the platform: OS access, instance compatibility, PaaS preference, scale, region, or hybrid management.
  • Do not choose a VM merely because it is familiar; choose it only when the requirement needs infrastructure control.
Section 1 continues in Pro.

Unlock Pro to read the full Plan and deploy Azure SQL solutions lesson plus every remaining Microsoft DP-300 Study Guide section.

Unlock with Pro
Section 2 Configure resources for scale and performance Pro
Configure resources for scale and performance unlocks with Pro.

Unlock Pro to read the full 5 topics flashcard-note study guide for this section.

Unlock with Pro
Section 3 Plan and implement a migration strategy Pro
Plan and implement a migration strategy unlocks with Pro.

Unlock Pro to read the full 7 topics flashcard-note study guide for this section.

Unlock with Pro
Section 4 Configure database authentication and authorization Pro
Configure database authentication and authorization unlocks with Pro.

Unlock Pro to read the full 8 topics flashcard-note study guide for this section.

Unlock with Pro
Section 5 Implement security for data at rest and data in transit Pro
Implement security for data at rest and data in transit unlocks with Pro.

Unlock Pro to read the full 6 topics flashcard-note study guide for this section.

Unlock with Pro
Section 6 Implement compliance controls for sensitive data Pro
Implement compliance controls for sensitive data unlocks with Pro.

Unlock Pro to read the full 6 topics flashcard-note study guide for this section.

Unlock with Pro
Section 7 Monitor resource activity and performance Pro
Monitor resource activity and performance unlocks with Pro.

Unlock Pro to read the full 6 topics flashcard-note study guide for this section.

Unlock with Pro
Section 8 Monitor and optimize query performance Pro
Monitor and optimize query performance unlocks with Pro.

Unlock Pro to read the full 7 topics flashcard-note study guide for this section.

Unlock with Pro
Section 9 Configure database solutions for optimal performance Pro
Configure database solutions for optimal performance unlocks with Pro.

Unlock Pro to read the full 9 topics flashcard-note study guide for this section.

Unlock with Pro
Section 10 Create and manage SQL Server Agent jobs Pro
Create and manage SQL Server Agent jobs unlocks with Pro.

Unlock Pro to read the full 4 topics flashcard-note study guide for this section.

Unlock with Pro
Section 11 Automate deployment of database resources Pro
Automate deployment of database resources unlocks with Pro.

Unlock Pro to read the full 5 topics flashcard-note study guide for this section.

Unlock with Pro
Section 12 Create and manage database tasks in Azure Pro
Create and manage database tasks in Azure unlocks with Pro.

Unlock Pro to read the full 4 topics flashcard-note study guide for this section.

Unlock with Pro
Section 13 Plan an HA/DR strategy for database solutions Pro
Plan an HA/DR strategy for database solutions unlocks with Pro.

Unlock Pro to read the full 4 topics flashcard-note study guide for this section.

Unlock with Pro
Section 14 Plan and perform backup and restore of a database Pro
Plan and perform backup and restore of a database unlocks with Pro.

Unlock Pro to read the full 6 topics flashcard-note study guide for this section.

Unlock with Pro
Section 15 Configure HA/DR for database solutions Pro
Configure HA/DR for database solutions unlocks with Pro.

Unlock Pro to read the full 7 topics flashcard-note study guide for this section.

Unlock with Pro