EnglishDeutschFrançaisEspañolPortuguês

Microsoft · DP-300 · Associate

Administering Microsoft Azure SQL Solutions (DP-300) — Practice Questions and Mock Exam

The DP-300 certification validates skills in planning, implementing, and managing data platform solutions on Azure.

Practice for freeTry a practice question first
Try a practice question firstPractice for free
Start practicing DP-300 freeBuy DP-300 access for $29.99
50Questions per Pass-IT mock exam
100minPass-IT mock exam time limit

Official DP-300 exam: 700 out of 1000 points to pass.

Checked against Microsoft · August 2026 · Current exam version

Try Pass-IT

See what learning with Pass-IT is like.

Answer a DP-300 sample question and read the explanation with its source. Right here, with no sign-up.

Configure and manage automation of tasks1 / 5

You are configuring an Azure Automation runbook to perform maintenance on Azure SQL Database. The runbook needs to authenticate to Azure without storing credentials. Which authentication method should you use?

AlexFull explanation from Alex

System-assigned managed identity is the recommended authentication method for Azure Automation runbooks accessing Azure SQL Database. Microsoft deprecated Run As accounts in September 2023. Managed identities eliminate credential storage, automatic secret rotation concerns, and integrate natively with Azure RBAC. The identity is tied to the Automation account lifecycle and can be assigned roles like SQL DB Contributor or specific SQL permissions via Microsoft Entra authentication. Certificate-based auth and client secrets still require secret management overhead. Ref: learn.microsoft.com/azure/automation/managed-identity

Sourcelearn.microsoft.com

Plan and configure a high availability and disaster recovery (HA/DR) environment4 / 5

You are performing a DR drill for Azure SQL Database failover groups. After the drill, you need to fail back to the original primary. Does performing a planned failover back to the original primary region require any data resynchronization?

AlexFull explanation from Alex

True. A planned failover (failback) back to the original primary region DOES require data synchronization. Per Microsoft docs: "Failover performs full data synchronization between primary and secondary databases before the secondary switches to the primary role. This guarantees no data loss." During the period the original primary was the secondary, it received replicated changes. Before it can become primary again, full synchronization ensures both replicas are consistent. This sync is automatic but adds time proportional to accumulated changes. This differs from forced failover, which skips sync and risks data loss. Ref: learn.microsoft.com/azure/azure-sql/database/failover-group-sql-db

Sourcelearn.microsoft.com

How to prepare for DP-300 with Pass-IT.

Currently 373 practice questions for DP-300, with new ones added regularly. Focus on what you still need to learn.

Get past difficult questions.

Understand why an answer is correct. Alex explains the concepts and answers your follow-up questions so you can apply what you learn to the next task.

Meet Alex →

Conversation preview · DP-300

Runbook identity

  1. You

    How can my runbook sign in without a stored secret?

  2. Alex · AI tutor

    Use the Automation account’s system-assigned managed identity.

    Read the Microsoft documentation ↗
  3. You

    Does that automatically grant database access?

  4. Alex · AI tutor

    No. Grant the identity the permissions needed for the maintenance task; authentication and authorization are separate.

    Read the Microsoft documentation ↗

Make your study time count.

Practice at your level.
For new practice sessions, Pass-IT adjusts the difficulty based on your previous answers.

Learn from mistakes.
Incorrect answers automatically become flashcards. When you review them, you rate how confidently you remember; Pass-IT schedules the next review.

See how focused practice works →

Animated feature preview

Turn your mistakes into knowledge you can rely on.

How Pass-IT works

Your review

Answered a question incorrectly?

Pass-IT saves it for your review.

DP-300 · Question excerpt

Runbook identity

View the full question

You are configuring an Azure Automation runbook to perform maintenance on Azure SQL Database. The runbook needs to authenticate to Azure without storing credentials. Which authentication method should you use?

Understand the correct answer.

System-assigned managed identity

A managed identity avoids storing credentials in the runbook. Required access still needs to be granted.

Read the Microsoft documentation ↗

How confidently do you remember?

During review, you assess how well you still know the answer.

Correct after hesitating

Pass-IT schedules your next review.

The date depends on your self-assessment and previous reviews.

Simplified demonstration. No learning progress is saved.

Practice for the moment that counts.

Take a full mock exam with a time limit and find out whether you can finish in time.

Your DP-300 mock exam

Questions
50
Minutes
100

Illustration of an exam session

  1. Start
  2. Answer questions
  3. Finish

Length and time limit of the Pass-IT mock exam.

Go into your exam with more confidence.

Your Readiness Score helps you assess whether you are ready for the exam. Results by exam domain show you where you should keep practicing.

Your money back if you fail despite 80% Readiness.
If your Readiness Score is at least 80% when you take the exam and you still fail, we refund the Pass-IT purchase price for this certification.

For active, paid access. Submit proof of failing within 14 days.

Further guarantee conditions

You need at least 80% Readiness and active, paid access to the certification when you take the exam. Take the exam within your access period and submit official proof of failing within 14 days after the exam.

For purchases through Apple or Google, refunds are handled by the respective store. See the full terms for further details.

Read the guarantee terms →

The Readiness Score describes your practice progress, not a probability of passing.

Guarantee requirement

80%

At least 80% Readiness
when you take the exam

Money back if you fail

Question counts and mock exam settings from the current Pass-IT catalog.

Exam domains

What you practice for DP-300.

Exam topics, relevant practice and sources you can check.

SQL deployment, scaling and migration15–20% of the exam104 QuestionsPass-IT questions

Choose and deploy SQL platforms, then size and migrate their databases.

  • Choose SQL offerings and automated deployment methods, including hybrid, Arc and Fabric use cases; plan partitioning and sharding and maintain patches and updates.
  • Configure SQL Database, Managed Instance and SQL Server VMs for scale and performance, including table partitioning and compression.
  • Assess and implement online or offline migrations to Azure and between SQL services, copy or move Managed Instance databases and troubleshoot migration failures.
Official Microsoft objectives
Database access and data protection20–25% of the exam75 QuestionsPass-IT questions

Control who can access data and protect sensitive information.

  • Configure SQL and Entra authentication, users and least-privilege permissions with graphical tools and T-SQL, and troubleshoot authentication and authorization.
  • Configure transparent and object-level encryption, Always Encrypted with enclave options, firewall rules, Private Link and service endpoints.
  • Classify sensitive data and implement audits, change tracking, dynamic masking, ledger and row-level security.
Official Microsoft objectives
Database and query performance20–25% of the exam80 QuestionsPass-IT questions

Measure database behavior and tune queries, configuration and maintenance.

  • Establish performance baselines, choose and interpret metrics, and monitor activity with database watcher and Extended Events.
  • Use Query Store, dynamic management views, execution plans and Intelligent Insights to resolve blocking and improve indexes and query structure.
  • Maintain indexes and statistics, check integrity, configure automatic tuning, server and database settings, Resource Governor and scaling, and choose intelligent query processing features.
Official Microsoft objectives
Automating database operations15–20% of the exam39 QuestionsPass-IT questions

Schedule maintenance, automate deployment and monitor database jobs.

  • Schedule SQL Server Agent jobs, configure alerts and notifications and troubleshoot job failures.
  • Automate deployments with ARM, Bicep, PowerShell and Azure CLI, then monitor and troubleshoot them.
  • Create elastic and automated database jobs, set alerts and notifications and diagnose task failures.
Official Microsoft objectives
Availability, backup and recovery20–25% of the exam75 QuestionsPass-IT questions

Plan and test how SQL databases remain available and recover from failure.

  • Choose Azure or hybrid availability and recovery designs from acceptable data-loss and recovery-time targets, and define a test procedure.
  • Back up and restore with native tools, T-SQL and cloud storage; perform point-in-time recovery and configure long-term retention.
  • Configure geo-replication, Always On groups and failover cluster instances, failover groups and log shipping; monitor and troubleshoot the recovery setup.
Official Microsoft objectives
Question formats you can practice
Multiple Choice
Select one answer.
Multiple Response
Select multiple applicable answers.
True / False
Decide whether statements are true or false.
Drag & Drop
Match items to the appropriate targets.
Ordering
Put steps in the correct order.
Dropdown
Choose the appropriate entry from a dropdown list.

These are Pass-IT practice formats. Check the Microsoft certification page for the official exam information.

The ranges describe the weighting of exam topics. See Official Microsoft objectives for the current exam objectives.

Frequently asked questions

Your preparation

How much study time should I plan for DP-300?

For planning, Pass-IT estimates roughly 30–75 hours. Relevant experience may put you toward the lower end; starting from scratch may put you toward the higher end. Your needs may fall outside this range. This is not a time requirement from Microsoft or a promise that you will be exam-ready within that time.

Do you need DP-900 before DP-300?

No. Microsoft records no prerequisite, so DP-300 can be booked directly. DP-900 is a fundamentals exam about data concepts rather than administration, so it helps if Azure data services are new to you and adds little if you already run SQL Server. The catalog budget for DP-300 is around 50 hours.

Using Pass-IT

What language are Pass-IT questions in?

Questions in the app are currently in English. Translations of the sample questions on this page apply only to this preview. Check with Microsoft for the languages available for the official exam.

How long does my DP-300 access last?

Access covers this certification for 12 months. You pay once, with no automatic renewal.

When does the money-back guarantee apply?

The guarantee refunds the Pass-IT purchase price for this certification. You need eligible paid access and a Readiness Score of at least 80% from your practice results when you take the exam. This score can only reach 80% after at least 50 answered questions and is not a validated probability of passing. Take the exam during your access period and submit official proof of failing within 14 days. Guarantee terms

About the DP-300 exam

Where can I take the DP-300 exam?

Pearson VUE online proctored or at authorized testing centers worldwide.

How long is the Administering Microsoft Azure SQL Solutions exam?

The DP-300 exam has 50 questions and a 100-minute time limit.

DP-300 or the Fabric exams?

DP-300 is about administering Azure SQL: security, performance, automation and recovery for a database platform. DP-600 and DP-700 are about Microsoft Fabric, where the work is analytics engineering and data engineering rather than database administration. If you are on call for a database, DP-300 is the right exam.

Does DP-300 expire?

Yes, after one year, like all Microsoft role-based certifications. The renewal is a free online assessment on Microsoft Learn rather than a repeat of the exam, and it opens six months before the expiry date.

Your preparation for DP-300

$29.99one-time

12 months of access for DP-300 · No automatic renewal

Buy DP-300 access

Questions in the app are currently in English.

Try 20 questions for freeFree account required. No credit card.

Already have an account? Log in

Prefer a subscription? View subscriptions →

Money back if you fail with at least 80% Readiness, for eligible purchases under the guarantee terms.

Guarantee terms

The guarantee refunds the Pass-IT purchase price for this certification. You need eligible paid access and a Readiness Score of at least 80% from your practice results when you take the exam. This score can only reach 80% after at least 50 answered questions and is not a validated probability of passing. Take the exam during your access period and submit official proof of failing within 14 days.

Full guarantee terms →

Related certifications

Administering Information Security in Microsoft 365Administering Windows ServerCollaboration Communications Systems EngineerConfiguring and Operating Microsoft Azure Virtual DesktopAll Microsoft certifications →