How many DP-300 practice questions are there?

269 questions across 1 version, each with the correct answer and an explanation.

Are there free DP-300 sample questions?

Yes. 20 sample questions are free; 10 are open to everyone and the rest unlock with a free account.

What does full access include?

Every DP-300 question in study, timed and flashcard modes, explanations for each answer, and progress that saves so you can resume.

What topics does DP-300 cover?

Plan and implement data platform resources (22%), Monitor, configure, and optimize database resources (22%), Configure and manage automation of tasks (17%), configure a high availability and disaster recovery (HA/DR) environment (22%).

How much does the DP-300 exam cost?

The DP-300 exam fee is $165 (USD; local pricing varies by region and provider).

What is the passing score for DP-300?

You need 700 on a 100-1000 scale to pass DP-300.

How long is the DP-300 certification valid?

1 year. Recertification: Annual renewal assessment.

DP-300Azure SQL Database Administrator practice test

269 Microsoft DP-300 practice questions with explanations, in study, timed and flashcard modes. 20 samples are free.

Full access

$69.99

All 269 questions with explanations · Study, timed and flashcard modes · Progress saved, resume any time

Try the free samples first

Questions: 269
Free samples: 20
Versions: 1
Updated: Jan 2026

Practice DP-300 in the simulator.

Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.

Open the simulator Try the free samples

DP-300, by the numbers.

Official specifications published by Microsoft.

Duration: 120 min
Questions: 40-60
Passing score: 700 on a 100-1000 scale
Exam fee: $165
In the bank: v1 (269)

Open the full exam guide

Everything about DP-300.

DP-300 · Microsoft · v2.0

Exam information

Official specifications published by Microsoft, plus what is in our question bank.

Duration: 120 min
Questions: 40-60
Passing score: 700 on a 100-1000 scale
Level: Associate
Question types: multiple_choice, multiple_response, drag_drop, case_study

What DP-300 covers

4 weighted domains. Open a domain for its topics, and a topic for its objectives. Practice questions are tagged to these.

Three ways to practise

Study mode

Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.

Open in the simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

DP-300Azure SQL Database Administrator practice test

Full access

Practice DP-300 in the simulator.

DP-300, by the numbers.

Everything about DP-300.

Exam information

What DP-300 covers

How to study for this exam?

Who should take this exam?

Three ways to practise

Study mode

Timed mode

Flashcards

DP-300 questions, answered

DP-300Azure SQL Database Administrator practice test

Full access

Practice DP-300 in the simulator.

DP-300, by the numbers.

Everything about DP-300.

Exam information

01Exam format120 min · 40-605

02Registration$165 · Pearson VUE, online proctoring3

03Validity1 year2

04In our question bankv1 (269)

What DP-300 covers

01Plan and implement data platform resources22%104 topics

1.1Implement a secure environment (15–20%)Implement implement a secure environment (15–20%)1 obj.

1.2Monitor, configure, and optimize database resources (20–25%)Implement monitor, configure, and optimize database resources (20–25%)1 obj.

1.3Configure and manage automation of tasks (15–20%)Implement configure and manage automation of tasks (15–20%)1 obj.

1.4Plan and configure a high availability and disaster recovery (HA/DR)Implement plan and configure a high availability and disaster recovery (ha/dr)1 obj.

1.5Deploy database offerings on selected platformsImplement deploy database offerings on selected platforms1 obj.

1.6Understand automated deploymentImplement understand automated deployment1 obj.

1.7Apply patches and updates for hybrid and infrastructure as a serviceImplement apply patches and updates for hybrid and infrastructure as a service1 obj.

1.8Deploy hybrid SQL Server solutionsImplement deploy hybrid sql server solutions1 obj.

1.9Recommend an appropriate database offering based on specificImplement recommend an appropriate database offering based on specific1 obj.

1.10Evaluate the security aspects of the possible database offeringImplement evaluate the security aspects of the possible database offering1 obj.

1.11Recommend a table partitioning solutionImplement recommend a table partitioning solution1 obj.

1.12Recommend a database sharding solutionImplement recommend a database sharding solution1 obj.

1.13Configure Azure SQL Database for scale and performanceImplement configure azure sql database for scale and performance1 obj.

1.14Configure Azure SQL Managed Instance for scale and performanceImplement configure azure sql managed instance for scale and performance1 obj.

1.15Configure SQL Server on Azure Virtual Machines for scale andImplement configure sql server on azure virtual machines for scale and1 obj.

1.16Configure table partitioningImplement configure table partitioning1 obj.

1.17Configure data compressionImplement configure data compression1 obj.

1.18Evaluate requirements for the migrationImplement evaluate requirements for the migration1 obj.

1.19Evaluate offline or online migration strategiesImplement evaluate offline or online migration strategies1 obj.

1.20Implement an online migration strategyImplement implement an online migration strategy1 obj.

1.21Implement an offline migration strategyImplement implement an offline migration strategy1 obj.

1.22Perform post migration validationsImplement perform post migration validations1 obj.

1.23Troubleshoot a migrationImplement troubleshoot a migration1 obj.

1.24Set up SQL Data Sync for AzureImplement set up sql data sync for azure1 obj.

1.25Implement a migration to AzureImplement implement a migration to azure1 obj.

1.26Implement a migration between Azure SQL servicesImplement implement a migration between azure sql services1 obj.

1.27Implement Azure SQL Managed Instance database copy and moveImplement implement azure sql managed instance database copy and move1 obj.

1.28Configure authentication by using Active Directory and Microsoft EntraImplement configure authentication by using active directory and microsoft entra1 obj.

1.29Create users from Microsoft Entra identitiesImplement create users from microsoft entra identities1 obj.

1.30Configure security principalsImplement configure security principals1 obj.

1.31Configure database and object-level permissions using graphical toolsImplement configure database and object-level permissions using graphical tools1 obj.

1.32Apply the principle of least privilege for all securablesImplement apply the principle of least privilege for all securables1 obj.

1.33Troubleshoot authentication and authorization issuesImplement troubleshoot authentication and authorization issues1 obj.

1.34Manage authentication and authorization by using T-SQLImplement manage authentication and authorization by using t-sql1 obj.

1.35Implement transparent data encryption (TDE)Implement implement transparent data encryption (tde)1 obj.

1.36Implement object-level encryptionImplement implement object-level encryption1 obj.

1.37Configure server- and database-level firewall rulesImplement configure server- and database-level firewall rules1 obj.

1.38Implement Always EncryptedImplement implement always encrypted1 obj.

1.39Implement Always Encrypted with VBS enclavesImplement implement always encrypted with vbs enclaves1 obj.

1.40Configure secure accessImplement configure secure access1 obj.

1.41Configure Transport Layer Security (TLS)Implement configure transport layer security (tls)1 obj.

1.42Apply a data classification strategyImplement apply a data classification strategy1 obj.

1.43Configure server and database auditsImplement configure server and database audits1 obj.

1.44Implement data change trackingImplement implement data change tracking1 obj.

1.45Implement dynamic data maskingImplement implement dynamic data masking1 obj.

1.46Manage database resources by using Microsoft PurviewImplement manage database resources by using microsoft purview1 obj.

1.47Implement database ledger in Azure SQLImplement implement database ledger in azure sql1 obj.

1.48Implement row-level securityImplement implement row-level security1 obj.

1.49Configure Microsoft Defender for Azure SQLImplement configure microsoft defender for azure sql1 obj.

1.50Prepare an operational performance baselineImplement prepare an operational performance baseline1 obj.

1.51Determine sources for performance metricsImplement determine sources for performance metrics1 obj.

1.52Interpret performance metricsImplement interpret performance metrics1 obj.

1.53Configure and monitor activity and performanceImplement configure and monitor activity and performance1 obj.

1.54Monitor by using SQL InsightsImplement monitor by using sql insights1 obj.

1.55Monitor by using database watcherImplement monitor by using database watcher1 obj.

1.56Monitor by using Extended EventsImplement monitor by using extended events1 obj.

1.57Configure Query StoreImplement configure query store1 obj.

1.58Monitor by using Query StoreImplement monitor by using query store1 obj.

1.59Identify sessions that cause blockingImplement identify sessions that cause blocking1 obj.

1.60Identify performance issues using dynamic management views (DMVs)Implement identify performance issues using dynamic management views (dmvs)1 obj.

1.61Identify and implement index changes for queriesImplement identify and implement index changes for queries1 obj.

1.62Recommend query construct modifications based on resource usageImplement recommend query construct modifications based on resource usage1 obj.

1.63Assess the use of query hints for query performanceImplement assess the use of query hints for query performance1 obj.

1.64Review execution plansImplement review execution plans1 obj.

1.65Monitor by using Intelligent InsightsImplement monitor by using intelligent insights1 obj.

1.66Implement index maintenance tasksImplement implement index maintenance tasks1 obj.

1.67Implement statistics maintenance tasksImplement implement statistics maintenance tasks1 obj.

1.68Implement database integrity checksImplement implement database integrity checks1 obj.