Free DP-300: Administering Relational Databases on Microsoft Azure Exam Questions and Answers
Administering Relational Databases on Microsoft Azure is exam DP-300, part of Microsoft Certifications. Microsoft exam codes name the solution area rather than the level — AZ for Azure, DP for data, MS for Microsoft 365, PL for Power Platform, SC for security, AI for Azure AI — with one reliable rule: any exam numbered 900 or 901 is Fundamentals. Every technical exam is scored from 1 to 1000 with 700 to pass, a scaled score Microsoft notes is explicitly not 70% of the marks.
Candidates comparing DP-300 exam dumps, ExamTopics and other DP-300 practice tests use this page for the answers and explanations behind each question. Download the free DP-300 PDF, then sit the timed DP-300 exam simulation before booking with Microsoft.
Last updated: October 4, 2026
- Exam code
- DP-300
- Provider
- Microsoft
- Questions in our bank
- 1000+
- Free to read
- First 10, with answers
- Official page
- Official Exam website
- Our test mode duration & pass mark
- 130 mins · 70%
Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.
Question #1
You have two on-premises servers that run Windows Server 2019 and host a Microsoft SQL Server 2017 Always On availability group named AG1. AG1 contains a single database named DB1. You have an Azure subscription. The subscription contains a virtual machine named VM1 that runs Linux. You need to migrate DB1 to a SQL Server 2019 instance on VM1. The solution must minimize the downtime of DB1 during the migration. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Work out the matching from the exhibit, then reveal.
Correct answer: To prepare for the migration = Create a SQL Server 2019 Always On availability group on VM1.; To perform the migration, use = Azure Migrate

Continue with DP-300: Administering Relational Databases on Microsoft Azure
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in DP-300: Administering Relational Databases on Microsoft Azure, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #2
You have an Azure Data Factory that contains 10 pipelines. You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory. What should you add to each pipeline?
Correct answer: A
Explanation
Azure Data Factory annotations help you easily filter different Azure Data Factory objects based on a tag. You can define tags so you can see their performance or find errors faster. Reference: https://www.techtalkcorner.com/monitor-azure-data-factory-annotations/
Continue with DP-300: Administering Relational Databases on Microsoft Azure
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in DP-300: Administering Relational Databases on Microsoft Azure, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #3
You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines. The virtual machine hosts a database named DB1. You need to monitor DB1 by using Extended Events. The solution must meet the following requirements: • Capture raw event data and store the data in Azure Storage. • Minimize the performance impact of capturing extended events. How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Work out the matching from the exhibit, then reveal.
Correct answer: ADD TARGET package0 = event_file; EVENT_RETENTION_MODE = ALLOW_MULTIPLE_EVENT_LOSS

Continue with DP-300: Administering Relational Databases on Microsoft Azure
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in DP-300: Administering Relational Databases on Microsoft Azure, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #4
You have an instance of SQL Server on Azure Virtual Machines named SQL1. SQL1 contains a database named DB1. You need to enable Transparent Data Encryption (TDE) for DB1. Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.

Work out the matching from the exhibit, then reveal.
Correct answer: 1 = a master key in the master database; 2 = a certificate in the master database; 3 = a database encryption key in DB1

Continue with DP-300: Administering Relational Databases on Microsoft Azure
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in DP-300: Administering Relational Databases on Microsoft Azure, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #5
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure SQL database named Sales. You need to implement disaster recovery for Sales to meet the following requirements: During normal operations, provide at least two readable copies of Sales. Ensure that Sales remains available if a datacenter fails. Solution: You deploy an Azure SQL database that uses the General Purpose service tier and geo-replication. Does this meet the goal?
Correct answer: A
Explanation
Instead deploy an Azure SQL database that uses the Business Critical service tier and Availability Zones. Note: Premium and Business Critical service tiers leverage the Premium availability model, which integrates compute resources (sqlservr.exe process) and storage (locally attached SSD) on a single node. High availability is achieved by replicating both compute and storage to additional nodes creating a three to four-node cluster. By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW). Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla
Continue with DP-300: Administering Relational Databases on Microsoft Azure
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in DP-300: Administering Relational Databases on Microsoft Azure, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #6
You have an Azure SQL database named db1 on a server named server1. The Intelligent Insights diagnostics log identifies that several tables are missing indexes. You need to ensure that indexes are created for the tables. What should you do?
Correct answer: C
Explanation
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview
Continue with DP-300: Administering Relational Databases on Microsoft Azure
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in DP-300: Administering Relational Databases on Microsoft Azure, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #7
You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper- V virtual machines. Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure. You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment. What should you include in the recommendation?
Correct answer: D
Explanation
Reference: https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-test-failover-to-azure
Continue with DP-300: Administering Relational Databases on Microsoft Azure
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in DP-300: Administering Relational Databases on Microsoft Azure, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #8
You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases. The databases perform slower than expected. You need to identify whether the performance issue relates to the use of tempdb on sqlsrv1. What should you do?
Correct answer: D
Explanation
The diagnostics log outputs tempDB contention details. You can use the information as the starting point for troubleshooting. You can use the Intelligent Insights performance diagnostics log of Azure SQL Database to troubleshoot performance issues. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance#tempdb https://docs.microsoft.com/en-us/azure/azure- sql/database/intelligent-insights-use-diagnostics-log
Continue with DP-300: Administering Relational Databases on Microsoft Azure
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in DP-300: Administering Relational Databases on Microsoft Azure, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #9
You have an Azure SQL database named DB1 that contains a table named Orders. The Orders table contains a row for each sales order. Each sales order includes the name of the user who placed the order. You need to implement row-level security (RLS). The solution must ensure that the users can view only their respective sales orders. What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Work out the matching from the exhibit, then reveal.
Correct answer: Create = A security policy in the Orders table; Control access to the rows by using = A table-valued function

Continue with DP-300: Administering Relational Databases on Microsoft Azure
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in DP-300: Administering Relational Databases on Microsoft Azure, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #10
You have an Azure Databricks resource. You need to log actions that relate to changes in compute for the Databricks resource. Which Databricks services should you log?
Correct answer: A
Explanation
Cloud Provider Infrastructure Logs. Databricks logging allows security and admin teams to demonstrate conformance to data governance standards within or from a Databricks workspace. Customers, especially in the regulated industries, also need records on activities like: User access control to cloud data storage Cloud Identity and Access Management roles User access to cloud network and compute Azure Databricks offers three distinct workloads on several VM Instances tailored for your data analytics workflow—the Jobs Compute and Jobs Light Compute workloads make it easy for data engineers to build and execute jobs, and the All-Purpose Compute workload makes it easy for data scientists to explore, visualize, manipulate, and share data and insights interactively. Reference: https://databricks.com/blog/2020/03/25/trust-but-verify-with-databricks.html
Continue with DP-300: Administering Relational Databases on Microsoft Azure
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in DP-300: Administering Relational Databases on Microsoft Azure, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Discussion
Explain your reasoning, not just the letterOther Microsoft certifications
- AZ-500: Microsoft Azure Security Technologies (opens in a new tab)
- MS-101: Microsoft 365 Mobility and Security (opens in a new tab)
- MS-102: Microsoft 365 Administrator (beta) (opens in a new tab)
- MS-100: Microsoft 365 Identity and Services (opens in a new tab)
- PL-900: Microsoft Power Platform Fundamentals (opens in a new tab)
- AZ-305: Designing Microsoft Azure Infrastructure Solutions (opens in a new tab)
- MS-900: Microsoft 365 Fundamentals (opens in a new tab)
- AZ-400: Microsoft Azure DevOps Solutions (opens in a new tab)
- AZ-900: Microsoft Azure Fundamentals (opens in a new tab)
- 70-740: Installation, Storage, and Compute with Windows Server 2016 (opens in a new tab)
- MD-102: Endpoint Administrator (beta) (opens in a new tab)
- PL-300: Microsoft Power BI Data Analyst (opens in a new tab)
Reviews
Write a review★★★★★
Exam Practice is worth every penny. The mock exams are realistic, and the feedback helped me focus on key areas.
Amit SharmaVerified buyer
★★★★★
I highly recommend Exam Practice. The feedback after each test helped me improve significantly, and I passed my exams easily.
Oscar NyströmVerified buyer
★★★★★
This platform is a lifesaver. The practice questions and explanations are so detailed. It’s the best study tool I’ve ever used.
Hannah SmithVerified buyer
FAQ
Learn More: https://learn.microsoft.com/en-us/credentials/
- Q1: How much does the DP-300 exam cost?
- A: As of October 2026 the DP-300 exam is listed at USD 165 in the United States. Microsoft prices exams by the country or region where they are proctored, so the fee differs elsewhere and excludes taxes.
- Q2: How many questions are on the DP-300 exam and how long is it?
- A: You have 100 minutes to complete the real exam. Microsoft says most of its certification exams contain 40 to 60 questions, and the exact number can change between versions.
- Q3: What is the passing score for the DP-300 exam?
- A: A scaled score of 700 or higher out of 1000 is required to pass.
- Q4: What domains does the DP-300 exam cover and how are they weighted?
- A: 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%, and plan and configure a high availability and disaster recovery environment 20-25%.
- Q5: Is the DP-300 exam changing soon?
- A: Yes. Microsoft is updating the English version of the exam on October 27, 2026, with the study guide's change log describing the edits as minor. Localized versions are usually updated about eight weeks after the English version.
- Q6: What certification does DP-300 earn and how long is it valid?
- A: Passing DP-300 earns the Microsoft Certified: Azure Database Administrator Associate certification. It expires after 12 months unless you renew it by passing a free online renewal assessment on Microsoft Learn.
- Q7: In which languages is the DP-300 exam offered and how is it delivered?
- A: The exam is delivered by Pearson VUE as a proctored exam at a test center or online, and is available in English, Simplified Chinese, Traditional Chinese, Japanese, Korean, French, German, Brazilian Portuguese, Italian and Spanish. During the exam you can open Microsoft Learn documentation in a split screen, although the timer keeps running.
- Q8: What happens if I fail the DP-300 exam?
- A: You can retake the exam 24 hours after a first failed attempt; waiting periods for later attempts are longer under Microsoft's retake policy. Microsoft recommends candidates have experience with Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure Virtual Machines and on-premises SQL Server, but there is no formal prerequisite.
- Q9: What is the DP-300: Administering Relational Databases on Microsoft Azure exam?
- A: DP-300: Administering Relational Databases on Microsoft Azure is a Microsoft certification exam. Judging by the questions in our bank, it concentrates on azure, named, app1, sqlsrv1 and table1.
- Q10: What topics does the DP-300: Administering Relational Databases on Microsoft Azure exam cover?
- A: Questions in our DP-300: Administering Relational Databases on Microsoft Azure bank cluster around azure, named, app1, sqlsrv1, table1, worth, sqldb1 and subscription. Working through the full set is the quickest way to find which of these you are weakest on.
- Q11: How should I prepare for DP-300: Administering Relational Databases on Microsoft Azure?
- A: Work through the DP-300: Administering Relational Databases on Microsoft Azure practice questions here, checking your answer on each one, then sit the practice test to rehearse the exam under timed conditions before the real thing.
- Q12: Are these real DP-300: Administering Relational Databases on Microsoft Azure exam questions?
- A: They are drawn from officially released past questions and from community members who have sat DP-300: Administering Relational Databases on Microsoft Azure. Answers are verified and updated weekly.
- Q13: Where do I register for the DP-300: Administering Relational Databases on Microsoft Azure exam?
- A: Register through Microsoft directly at https://learn.microsoft.com/en-us/credentials/. Exampractice is not affiliated with Microsoft and does not administer the exam.
- Q14: Is there a free DP-300: Administering Relational Databases on Microsoft Azure sample?
- A: Yes. Every DP-300: Administering Relational Databases on Microsoft Azure page shows a free sample of real questions. Upgrading opens the full bank and the practice test.
- Q15: What are Microsoft Certification Exams?
- A: Microsoft Certification Exams validate your expertise in using and managing Microsoft’s technologies and solutions, including Azure, Office 365, Windows, and more. These certifications demonstrate your proficiency in deploying, configuring, and optimizing Microsoft products to support business operations and IT infrastructure.
- Q16: Why should I pursue Microsoft Certification?
- A: Microsoft Certification enhances your professional credibility, showcasing your skills and knowledge in Microsoft technologies. This can lead to better job opportunities, higher salaries, and career advancement in IT, cloud computing, software development, and related fields.
- Q17: What are the benefits of Microsoft Certification?
- A: Benefits include recognition as a certified Microsoft professional, improved job performance, access to exclusive resources, continuing education opportunities, and staying current with the latest Microsoft technologies and best practices.
- Q18: Who should take Microsoft Certification Exams?
- A: IT professionals, system administrators, developers, cloud engineers, data analysts, and anyone involved in managing and implementing Microsoft solutions should consider these certifications to validate their expertise and advance their careers.
- Q19: What types of Microsoft Certification Exams are available?
- A: Microsoft offers various certification paths, including:
- Q20: How do I prepare for Microsoft Certification Exams?
- A: Preparation can include official Microsoft training courses, study guides, practice exams, online tutorials, and hands-on experience with Microsoft products and solutions.
- Q21: Where can I take Microsoft Certification Exams?
- A: Microsoft Certification Exams can be taken online with remote proctoring or at authorized Pearson VUE testing centers worldwide, providing flexibility to fit your schedule and location.
- Q22: How do Microsoft Certifications impact my career?
- A: Microsoft Certifications significantly boost your career by demonstrating your expertise to employers, making you a more competitive candidate for advanced roles and promotions in IT, cloud computing, software development, and other tech-related fields.
- Q23: Are there any prerequisites for Microsoft Certification Exams?
- A: Some exams may have prerequisites, such as foundational knowledge or prior experience with Microsoft products. Check the specific requirements for each certification path on the Microsoft Learn website.
- Q24: How often do I need to recertify for Microsoft Certifications?
- A: Microsoft Certifications typically require renewal every year or two, depending on the certification, to ensure that certified professionals stay updated with the latest technologies and industry practices.



