DP-300 Practice Test: Azure Database Administrator

Exam at a glance

Plan and implement data platform resources — 17%
Azure SQL Database & Managed Instance, SQL Server on Azure VMs & Azure Arc, Hyperscale, vCore, DTU, Elastic Pool, Table Partitioning & Sharding, Migration (DMS, DMA, BACPAC)
Implement a secure environment — 23%
Microsoft Entra ID & SQL Authentication, Database & Server Permissions (GRANT/REVOKE/DENY), Transparent Data Encryption (TDE) & Always Encrypted, Firewall, Private Link, Private Endpoint, Dynamic Data Masking, Audit, Row-Level Security
Monitor, configure, and optimize database resources — 23%
Query Store, DMV, Execution Plans, Extended Events, SQL Insights, Database Watcher, Index & Statistics Maintenance, DBCC CHECKDB, Automatic Tuning, FORCE_LAST_GOOD_PLAN, Resource Governor, MAXDOP, IQP
Configure and manage automation of tasks — 17%
SQL Server Agent Jobs, Schedules, Alerts, Database Mail & sp_send_dbmail, ARM, Bicep, Az.Sql Module, Azure CLI, DACPAC & BACPAC Deployment, Elastic Jobs, Azure Automation, Runbooks
Plan and configure a high availability and disaster recovery environment — 20%
RPO, RTO, SLA Strategy, Zone-Redundant & Geo-Redundant Configuration, Full, Differential, Log Backup, PITR, LTR, Active Geo-Replication & Failover Groups, Always On Availability Groups, FCI, Log Shipping

Practice modeSee the explanation right after each answer, so you learn as you go.
Study modeReview questions and explanations at your own pace, with no timer.
Exam modeA timed, randomized set that mirrors the real exam conditions.

The Administering Microsoft Azure SQL Solutions (DP-300) exam consists of 50 questions with a 100-minute time limit.

The passing score for the DP-300 exam is 700 out of 1000.

The DP-300 sample set (20 questions with full explanations) is free. The full bank of 370+ questions is available with a CloudMasterIT subscription.

The DP-300 certification is valid for 1 years after passing. Recertification is required after that.