DP-300 study notes
- Plan and implement data platform resources DP-300 notes on choosing between Azure SQL Database, Managed Instance and SQL Server on VMs, deployment, Arc, Fabric, partitioning, sharding, scaling, compression and migration. 15–20%
- Implement a secure environment DP-300 notes on Entra authentication, permissions, TDE, Always Encrypted, firewalls and private connectivity, classification, auditing, masking, ledger and row-level security. 20–25%
- Monitor, configure and optimize database resources DP-300 notes on baselines, metrics sources, database watcher, Extended Events, Query Store, blocking, DMVs, indexes, execution plans, maintenance, automatic tuning, Resource Governor and intelligent query processing. 20–25%
- Configure and manage automation of tasks DP-300 notes on SQL Server Agent jobs, ARM and Bicep, PowerShell and CLI deployment, elastic jobs, Azure Automation, Logic Apps, alerts and troubleshooting automated tasks. 15–20%
- Plan and configure a high availability and disaster recovery environment DP-300 notes on RPO and RTO, built-in HA, backups and point-in-time restore, long-term retention, backup to URL, active geo-replication, failover groups, Always On AGs and FCIs, log shipping, monitoring and testing. 20–25%