Skip to content

Azure DP-300 Certification Fact Sheet

Comprehensive Quick Reference Guide for Administering Microsoft Azure SQL Solutions

Table of Contents

  1. Exam Overview
  2. Database Deployment
  3. Security
  4. Monitoring & Performance
  5. Optimization
  6. High Availability & Disaster Recovery
  7. Automation
  8. Cost Management

Exam Overview

Exam Structure

  • Exam Code: DP-300: Administering Microsoft Azure SQL Solutions
  • Duration: 180 minutes (3 hours)
  • Questions: 40-60 questions
  • Passing Score: 700/1000
  • Cost: $165 USD
  • Question Types: Multiple choice, multiple select, drag-drop, case studies, hot areas

Official Resources

Exam Domain Breakdown

  1. Plan and Implement Data Platform Resources (20-25%)
  2. Implement a Secure Environment (15-20%)
  3. Monitor, Configure, and Optimize Database Resources (20-25%)
  4. Configure and Manage Automation of Tasks (15-20%)
  5. Plan and Configure High Availability and Disaster Recovery (20-25%)

Database Deployment

Azure SQL Deployment Options

Azure SQL Database

Azure SQL Managed Instance

SQL Server on Azure VMs

Deployment Methods and Tools

Migration and Hybrid Scenarios

Security

Authentication and Authorization

Azure Active Directory Integration

SQL Authentication and Access Control

Network Security

Data Encryption

Transparent Data Encryption (TDE)

Always Encrypted

Other Encryption Features

Security Monitoring and Compliance

Microsoft Defender for SQL

Auditing and Compliance

Monitoring & Performance

Azure Monitor Integration

Monitoring Fundamentals

Metrics and Alerts

Query Performance Monitoring

Query Performance Insight

Query Analysis Tools

Dynamic Management Views (DMVs)

Essential DMVs

Wait Statistics and Blocking

Optimization

Index Management

Index Strategies

Automatic Tuning

Query Optimization

Query Tuning Techniques

Performance Features

Resource Governance and Scaling

Compute and Storage Scaling

Read Scale-Out and Replicas

Resource Governor

High Availability & Disaster Recovery

High Availability Architecture

Built-in High Availability

Active Geo-Replication

Auto-Failover Groups

SQL Server Always On (IaaS)

Backup and Restore

Automated Backups

Point-in-Time Restore (PITR)

Geo-Restore

Copy and Export

Disaster Recovery Planning

Automation

Infrastructure as Code (IaC)

ARM Templates

Bicep

PowerShell Automation

Azure CLI Automation

Database Automation

Elastic Jobs

Azure Automation

Maintenance Plans and Jobs

CI/CD for Databases

Azure DevOps Integration

GitHub Actions

Cost Management

Pricing Models and Optimization

Resource Monitoring for Cost

Additional Resources

Tools and Utilities

Learning and Practice

Community and Support

Best Practices Guides

Quick Reference Commands

Azure CLI Quick Reference

# Create SQL Server
az sql server create --name myserver --resource-group myRG --location eastus --admin-user myadmin --admin-password MyP@ssw0rd

# Create SQL Database
az sql db create --resource-group myRG --server myserver --name mydb --service-objective S0

# Scale database
az sql db update --resource-group myRG --server myserver --name mydb --service-objective S2

# Configure geo-replication
az sql db replica create --resource-group myRG --server myserver --name mydb --partner-server mysecondaryserver --partner-resource-group mySecondaryRG

# Create failover group
az sql failover-group create --name myfailovergroup --resource-group myRG --server myserver --partner-server mysecondaryserver --failover-policy Automatic --grace-period 1

# PITR restore
az sql db restore --dest-name mydb-restored --resource-group myRG --server myserver --name mydb --time "2024-01-15T10:30:00Z"

PowerShell Quick Reference

# Create SQL Server
New-AzSqlServer -ResourceGroupName "myRG" -ServerName "myserver" -Location "East US" -SqlAdministratorCredentials (Get-Credential)

# Create SQL Database
New-AzSqlDatabase -ResourceGroupName "myRG" -ServerName "myserver" -DatabaseName "mydb" -Edition "Standard" -RequestedServiceObjectiveName "S2"

# Scale database
Set-AzSqlDatabase -ResourceGroupName "myRG" -ServerName "myserver" -DatabaseName "mydb" -Edition "Premium" -RequestedServiceObjectiveName "P2"

# Configure geo-replication
New-AzSqlDatabaseSecondary -ResourceGroupName "myRG" -ServerName "myserver" -DatabaseName "mydb" -PartnerResourceGroupName "mySecondaryRG" -PartnerServerName "mysecondaryserver"

# Create failover group
New-AzSqlDatabaseFailoverGroup -ResourceGroupName "myRG" -ServerName "myserver" -PartnerServerName "mysecondaryserver" -FailoverGroupName "myfailovergroup" -FailoverPolicy Automatic -GracePeriodWithDataLossHours 1

# PITR restore
Restore-AzSqlDatabase -FromPointInTimeBackup -PointInTime "2024-01-15T10:30:00Z" -ResourceGroupName "myRG" -ServerName "myserver" -TargetDatabaseName "mydb-restored" -ResourceId /subscriptions/{SubID}/resourceGroups/myRG/providers/Microsoft.Sql/servers/myserver/databases/mydb

T-SQL Quick Reference

-- Check database size and usage
SELECT
    database_name,
    SUM(size_gb) as total_size_gb,
    SUM(allocated_gb) as allocated_gb
FROM sys.dm_db_resource_stats;

-- View current connections
SELECT
    session_id,
    login_name,
    status,
    database_name
FROM sys.dm_exec_sessions
WHERE is_user_process = 1;

-- Check running queries
SELECT
    r.session_id,
    r.status,
    r.command,
    r.wait_type,
    r.total_elapsed_time,
    t.text
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t;

-- Create database user from Azure AD
CREATE USER [user@domain.com] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [user@domain.com];

-- Enable Query Store
ALTER DATABASE [mydb] SET QUERY_STORE = ON;
ALTER DATABASE [mydb] SET QUERY_STORE (OPERATION_MODE = READ_WRITE);

-- Configure geo-replication (primary)
ALTER DATABASE [mydb] ADD SECONDARY ON SERVER [mysecondaryserver];

-- Failover to secondary
ALTER DATABASE [mydb] FAILOVER;

Exam Tips and Strategy

Key Focus Areas

  1. Deployment Models: Understand when to use SQL Database vs Managed Instance vs SQL VM
  2. Security Layers: Know all security features (TDE, Always Encrypted, DDM, firewall, AAD)
  3. HA/DR Solutions: Master geo-replication, failover groups, PITR, and Always On
  4. Monitoring Tools: Query Performance Insight, Query Store, Extended Events, DMVs
  5. Performance Tuning: Indexes, automatic tuning, query optimization, resource scaling
  6. Backup/Restore: Understand PITR, LTR, geo-restore, and retention policies
  7. Automation: Know PowerShell, CLI, ARM/Bicep, Elastic Jobs

Common Exam Scenarios

  • Choosing the right deployment option based on requirements
  • Implementing security for compliance requirements
  • Designing HA/DR solutions with RTO/RPO requirements
  • Troubleshooting performance issues using monitoring tools
  • Automating maintenance and deployment tasks
  • Configuring backup retention and performing restores
  • Migrating on-premises databases to Azure
  • Optimizing costs while meeting performance requirements

Study Approach

  1. Complete Microsoft Learn DP-300 learning path
  2. Get hands-on experience with all deployment options
  3. Practice backup/restore and failover scenarios
  4. Learn to use monitoring and troubleshooting tools
  5. Master PowerShell and CLI commands
  6. Understand pricing models and cost optimization
  7. Review official documentation linked in this fact sheet
  8. Take practice exams to identify knowledge gaps

Document Statistics: - Total Sections: 8 major domains - Embedded Links: 120 documentation links - Lines: 700+ comprehensive coverage - Last Updated: 2025-10-13

Good luck with your DP-300 certification exam!