DP-300

Azure SQL Administrator DP-300 practice exams

241 questions in 5 timed practice tests. Each test has about 50 questions and a 100-minute limit. The pass mark is 70%. Results are split across the 5 exam domains.

Exam at a glance

DP-300 practice exam settings
Practice tests 5
Questions in total 241
Questions per test About 50
Time limit per test 100 minutes
Pass mark 70%
Question types Single answer and multiple answer (26 multiple-answer questions)
Level Associate
Category Data & Analytics

These are the settings of our practice tests. Check the official Microsoft exam page for the current exam format before you book.

Domains and weights

DP-300 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Plan and implement data platform resources 17% 41
Implement a secure environment 22% 53
Monitor, configure, and optimize database resources 22% 53
Configure and manage automation of tasks 17% 41
Plan and configure a high availability and disaster recovery (HA/DR) environment 22% 53

Sample questions

Question 1 of 3

A retailer is moving a 3 TB SQL Server 2019 database to Azure. The application uses cross-database queries, SQL Server Agent jobs, and Service Broker, and the team wants a fully managed PaaS service with no operating system to patch. Which deployment option should they choose?

  1. A Azure SQL Database in a vCore-based elastic pool with elastic jobs replacing SQL Agent
  2. B SQL Server 2022 on an Azure virtual machine registered with the SQL IaaS Agent extension
  3. C Azure SQL Managed Instance in the General Purpose service tier, migrated with Database Migration Service (correct answer)
  4. D Azure SQL Database single database in the Hyperscale service tier
Why: Managed Instance is PaaS yet keeps instance-scoped features such as cross-database queries, SQL Server Agent and Service Broker. Azure SQL Database (single or pooled, any tier) does not support Service Broker or cross-database queries in the same way, so Hyperscale and the elastic pool fail the compatibility requirement. A SQL Server VM supports everything but is IaaS, so the team would still patch the operating system.

Question 2 of 3

A DBA must migrate a 2 TB SQL Server 2017 database to Azure SQL Managed Instance with minimal downtime. Full and log backups already land in Azure Blob Storage every 15 minutes. The DBA wants to restore from those files continuously and cut over when ready. Which service should be used?

  1. A Log Replay Service restoring the backups from Blob Storage onto the managed instance (correct answer)
  2. B Azure Data Factory copy activities that move each table from SQL Server into the managed instance
  3. C Transactional replication with the managed instance configured as a publisher
  4. D A BACPAC export imported into the managed instance through the Azure portal
Why: Log Replay Service continuously restores full, differential and log backups from Blob Storage to Managed Instance and completes with a final cutover, giving minimal downtime. A BACPAC import is an offline, slow operation for 2 TB. The managed instance would need to be a subscriber, not a publisher, to receive data, and Data Factory copies data but not the full database schema and objects in a log-consistent way.

Question 3 of 3

A table stores customer email addresses and phone numbers. Support agents must see only partially obscured values such as aXXX@XXXX.com, while the billing team must see full values. No application changes are allowed. What should you implement?

  1. A Always Encrypted with randomized encryption and give billing access to the column master key
  2. B Row-level security with a filter predicate that hides rows from support agents
  3. C Dynamic data masking on the columns and grant UNMASK to the billing team (correct answer)
  4. D Transparent data encryption with a customer-managed key so agents cannot read the files
Why: Dynamic data masking obfuscates column values in query results for users without UNMASK, needs no application change, and can be lifted for specific users. Always Encrypted would require client driver configuration and would show ciphertext rather than a partial mask. Row-level security hides whole rows rather than masking values, and TDE protects files at rest but returns clear data to any authorized query.

What your score report looks like

Example attempt, DP-300 practice test 3

78%

Passed
Pass mark 70%

Score by exam domain
DomainWeightYour score%
Plan and implement data platform resources 17%
88
Implement a secure environment 22%
81
Monitor, configure, and optimize database resources 22%
76
Configure and manage automation of tasks 17%
58
Plan and configure a high availability and disaster recovery (HA/DR) environment 22%
84

Study next: Configure and manage automation of tasks. It is below the pass mark and carries 17% of the exam.

Domains and pass mark from our DP-300 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Implement a secure environment and Monitor, configure, and optimize database resources, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the DP-300 practice exams

Are these real DP-300 exam questions?
No. We write every question ourselves and map it to the published DP-300 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Microsoft. DP-300 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
AB-100AB-100 Agentic AI Business Solutions Architect Microsoft Professional 250 100 $14.99
AB-730AI Business Professional AB-730 Microsoft Professional 250 100 $14.99
AZ-305Azure Solutions Architect AZ-305 Microsoft Professional 250 100 $14.99
SC-100Cybersecurity Architect SC-100 Microsoft Professional 250 120 $14.99
AZ-140Azure Virtual Desktop AZ-140 Microsoft Specialty 251 100 $14.99
DP-420Microsoft DP-420 Microsoft Specialty 250 100 $14.99