DP-300 practice examsFinished
Microsoft Certified: Azure Database Administrator Associate
Running SQL Server and Azure SQL together: choosing the deployment option the compatibility requirement allows, securing it, finding out why a query got slow, automating the routine, and surviving a failure.
What you get
Papers are cut from the bank and weighted like the real exam, and no question appears in two of them. Every wrong answer comes back on later days until you have it right.
What the exam covers
| Plan and implement data platform resources | 15-20% |
| Implement a secure environment | 20-25% |
| Monitor, configure, and optimize database resources | 20-25% |
| Configure and manage automation of tasks | 15-20% |
| Plan and configure a high availability and disaster recovery (HA/DR) environment | 20-25% |
Two sample questions
1. Which feature adapts a plan while the query is running?
- A manual hint applied by the developer later
- Intelligent query processing in the engine — correct
- A note describing the wanted behaviour
- A memory of the earlier tuning effort
Why: The engine adjusts the memory grant and the join as it learns.
2. Which column master key can be used for computations inside a secure enclave?
- One created with ENCLAVE_COMPUTATIONS — correct
- One stored in the Windows certificate store
- One protected by the database master key
- One generated on the database server
Why: Only enclave-enabled keys, and column keys they protect, work in the enclave.
The real DP-300 exam
| Length | 100 minutes |
|---|---|
| Questions | Not published by Microsoft; commonly reported as 40-60 |
| Pass mark | 700 of 1000 |
| Price | $165 USD |
| Recommended before you sit it | None formally. Working knowledge of T-SQL and SQL Server administration is assumed. |
| Valid for | 1 year, renewed free online |
Exam facts as published by Microsoft; always check the vendor’s page before you book.
Study DP-300 with Chiron
Chiron is invitation-only while we are in beta, and nothing is for sale yet: invited accounts use every paper, drill and course note for free.