DP-300 Microsoft · Database

DP-300 practice test

Administering Microsoft Azure SQL Solutions. Practice exam aligned to the DP-300 skills measured (October 2026): planning and migrating Azure SQL, security and compliance, monitoring and tuning, automation, and high availability and disaster recovery.

  • 6 practice tests + challenge test
  • 350 questions
  • 40 questions, 100 min per test
  • Pass at 70%

Take the free DP-300 diagnostic10 questions, no card needed

Free DP-300 sample questions

3 questions from the free diagnostic, with answers and explanations.

Question 1 · Plan and deploy Azure SQL solutions

Which Azure SQL option is a fully managed (PaaS) service with near-complete compatibility with SQL Server, including SQL Server Agent and cross-database queries?

  1. Azure SQL Managed Instance
  2. Azure SQL Database single database
  3. SQL Server on an Azure virtual machine
  4. Azure SQL Database Hyperscale
Show answer

Answer: A (Azure SQL Managed Instance)

Managed Instance offers instance-level SQL Server features as PaaS. A VM is IaaS, and single databases don't have SQL Server Agent or cross-database queries.

Question 2 · Configure database authentication and authorization

Users must sign in to an Azure SQL Database with their Microsoft Entra accounts. What must be configured on the logical server first?

  1. A Microsoft Entra admin for the server
  2. A SQL login for each user in master
  3. A firewall rule for each user's address
  4. A system-assigned managed identity
Show answer

Answer: A (A Microsoft Entra admin for the server)

Until the server has a Microsoft Entra admin, it can't authenticate Entra identities. The admin can then create contained database users FROM EXTERNAL PROVIDER.

Question 3 · Implement security for data at rest and data in transit

Which feature encrypts the data files, log files and backups of an Azure SQL Database at rest, and is on by default?

  1. Transparent data encryption (TDE)
  2. Always Encrypted
  3. Always Encrypted with secure enclaves
  4. Backup encryption with a certificate
Show answer

Answer: A (Transparent data encryption (TDE))

TDE encrypts storage at rest without application changes. TLS protects data in transit, and Always Encrypted protects chosen columns end to end.

Try the full diagnostic free

What the DP-300 practice covers

Share of practice questions per skill area.

  • Configure database authentication and authorization8%
  • Implement security for data at rest and data in transit8%
  • Monitor resource activity and performance8%
  • Monitor and optimize query performance8%
  • Configure database solutions for optimal performance8%
  • Configure HA/DR for database solutions8%
  • Plan and deploy Azure SQL solutions6%
  • Configure resources for scale and performance6%
  • Plan and implement a migration strategy6%
  • Implement compliance controls for sensitive data6%
  • Create and manage SQL Server Agent jobs6%
  • Create and manage database tasks in Azure6%
  • Plan an HA/DR strategy for database solutions6%
  • Plan and perform backup and restore of a database6%
  • Automate deployment of database resources4%

Question formats

  • Single choice
  • Multiple select
  • Hotspot (drop-down and yes/no)
  • Drag-and-drop matching
  • Drag-and-drop select and place
  • Case studies
  • Exhibits (screenshots, diagrams and code)

Career path: Database

Run Azure SQL in production, build AI-enabled SQL databases, or build AI apps on Azure Cosmos DB: security, performance, HA/DR, partitioning, vector search and RAG.

  1. DP-900
  2. DP-300
  3. DP-800
  4. DP-420

Guides

DP-300 practice test FAQ

Is there a free DP-300 practice test?

Yes. Create a free account and take the DP-300 free diagnostic: 10 questions across every skill area of the exam, with a study plan for the topics to work on. You can retake it as often as you like.

How many questions are in each ExamKite DP-300 practice test?

Each full practice test has 40 questions with a 100-minute timer, and you pass at 70%. There are 6 practice tests plus a harder challenge test, with 350 questions in total.

Which question formats does the DP-300 practice include?

Single choice, multiple select, hotspot (drop-down and yes/no), drag-and-drop matching, drag-and-drop select and place, case studies and exhibits (screenshots, diagrams and code), the same formats you meet on the real exam.

Are these real DP-300 exam questions?

No. They are original questions written for ExamKite and mapped to the Microsoft skills outline, never copied from the real exam. Using leaked exam questions breaks the certification provider's exam rules and can get your certification revoked.

More answers in the full FAQ.

Ready to practice for DP-300?

Start with the free diagnostic and get a study plan for the topics you miss.

Create a free account