Microsoft Certified: Administering Microsoft Azure SQL Solutions (DP300)

Administering Microsoft Azure SQL Solutions (DP-300T00)

• Describe Microsoft Intelligent Data Platform roles
• Understand SQL Server in an Azure virtual machine
• Design Azure SQL Database for cloud-native applications
• Explore Azure SQL Database Managed Instance

Module 2: Deploy IaaS solutions with Azure SQL

• Explain IaaS options to deploy SQL Server in Azure
• Understand hybrid scenarios
• Explore performance and security
• Explain high availability and disaster recovery options

Module 3: Deploy PaaS solutions with Azure SQL

• Explain PaaS options for deploying SQL Server in Azure
• Explore single SQL database
• Deploy SQL database elastic pool
• Understand SQL database hyperscale
• Examine SQL managed instance
• Describe SQL Edge

Module 4: Evaluate strategies for migrating to Azure SQL

• Understand compatibility level
• Understand Azure preview features
• Describe Azure database migration options

Module 5: Migrate SQL workloads to Azure SQL Databases

• Choose the right SQL Server Instance option in Azure
• Migrate SQL Server to Azure SQL Database offline
• Migrate SQL Server to Azure SQL Database online
• Load and move data to Azure SQL Database

Module 6: Migrate SQL workloads to Azure Managed Instances

• Evaluate migration scenarios to SQL Database Managed Instance
• Migrate to SQL Database Managed Instance
• Load and Move data to SQL Database Managed Instance

Module 7: Configure database authentication and authorization

• Describe Active Directory and Azure Active Directory
• Describe authentication and identities
• Describe Security Principals
• Describe database and object permissions
• Identify authentication and authorization failures

Module 8: Protect data in-transit and at rest

• Explore Transparent Data Encryption
• Configure server and database firewall rules
• Explain object encryption and secure enclaves
• Enable encrypted connections
• Describe SQL injection
• Understand Azure Key Vault

Module 9: Implement compliance controls for sensitive data

• Explore data classification
• Explore server and database audit
• Implement Dynamic Data Masking
• Implement Row Level security
• Understand Microsoft Defender for SQL
• Explore Azure SQL Database Ledger
• Implement Azure Purview

Module 10: Describe performance monitoring

• Describe performance monitoring tools
• Describe critical performance metrics
• Establish baseline metrics
• Explore extended events
• Describe Azure SQL Insights
• Explore Query Performance Insight

Module 11: Configure SQL Server resources for optimal performance

• Explain how to optimize Azure storage for SQL Server virtual machines
• Describe virtual machine resizing
• Optimize database storage
• Control SQL Server resources

Module 12: Configure databases for optimal performance

• Explore database maintenance checks
• Describe database scoped configuration options
• Describe automatic tuning
• Describe intelligent query processing

Module 13: Explore query performance optimization

• Understand query plans
• Explain estimated and actual query plans
• Describe dynamic management views and functions
• Explore Query Store
• Identify problematic query plans
• Describe blocking and locking

Module 14: Evaluate performance improvements

• Describe wait statistics
• Tune and maintain indexes
• Understand query hints

Module 15: Explore performance-based design

• Describe normalization
• Choose appropriate data types
• Design indexes

Module 16: Automate deployment of database resources

• Describe deployment models in Azure
• Automate deployment by using Azure Resource Manager templates and Bicep
• Automate deployment by using PowerShell
• Automate deployment by using Azure CLI

Module 17: Create and manage SQL Agent jobs

• Create a SQL Server maintenance plan
• Describe task status notifications

Module 18: Manage Azure PaaS tasks using automation

• Explore Elastic jobs
• Understand Azure Automation
• Build an automation runbook
• Automate database workflows by using Logic Apps
• Monitor automated tasks

Module 19: Describe high availability and disaster recovery strategies

• Describe recovery time objective and recovery point objective
• Explore high availability and disaster recovery options
• Describe Azure high availability and disaster recovery features for Azure Virtual Machines
• Describe high availability and disaster recovery options for PaaS deployments
• Explore an IaaS high availability and disaster recovery solution
• Describe hybrid solutions

Module 20: Explore IaaS and PaaS solutions for high availability and disaster recovery

• Describe failover clusters in Windows Server
• Configure Always-on availability groups
• Describe temporal tables in Azure SQL Database
• Describe active geo-replication for Azure SQL Database
• Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance

Module 21: Back up and restore databases

• Back up and restore SQL Server running on Azure virtual machines
• Back up a SQL Server virtual machine
• Back up and restore a database using Azure SQL Database