Microsoft DP-300 Practice Exam Questions & Answers
Microsoft DP-300 Exam Details
Key details for this exam, checked against the published exam outline
- Exam Code
- DP-300
- Full Name
- Administering Microsoft Azure SQL Solutions
- Issuing Body
- Microsoft
- Question Format (Our Bank)
- Multiple Choice, Hotspot, Order List, Drag & Drop, Case Studies
- Delivery
- Online proctored or at a test centre
- Eligibility
- No prerequisites
- Full Question Set
- 414 questions Get All Questions
Free DP-300 Practice Questions
Each question shows the correct answer and an explanation of why it is right
Question 1 Domain 2 Implement a secure environment
You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine
has 4 vCPUs and 28 GB of memory.
You scale up the virtual machine to 8 vCPUSs and 64 GB of memory.
You need to provide the lowest latency for tempdb.
What is the total number of data files that tempdb should contain?
The number of files depends on the number of (logical) processors on the machine. As a general rule, if the number of logical processors is less than or equal to eight, use the same number of data files as logical processors. If the number of logical processors is greater than eight, use eight data files and then if contention continues, increase the number of data files by multiples of 4 until the contention is reduced to acceptable levels or make changes to the workload/code.
https://docs.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database
Question 2 Domain 1 Plan and implement data platform resources
You have an Azure subscription that contains 20 Azure SQL databases.
You create a Transact-SQL statement to perform index maintenance on a database.
You need to schedule the statement to run once daily against each database by using Transact-SQL commands.
What should you use to schedule the statement?
To schedule a Transact-SQL statement to run once daily against each of 20 Azure SQL databases using Transact-SQL commands, you should use Elastic Jobs (specifically Azure SQL Database Elastic Jobs).
Elastic Jobs provide:
- Multi-database scheduling - Execute the same job across multiple Azure SQL databases with a single configuration
- Transact-SQL support - Jobs can execute T-SQL scripts and statements
- Flexible scheduling - Support for recurring schedules including daily execution
- Centralized management - All 20 databases can be managed as a group through a single job configuration
- Scalability - Designed specifically for managing jobs across multiple databases at scale
SQL Server Agent jobs (traditional approach) require individual configuration on each database and aren't ideal for managing 20 separate databases from a centralized perspective.
Question 3 Domain 1 Plan and implement data platform resources
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 Data Lake Storage account that contains a staging zone.
You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.
Solution: You schedule an Azure Databricks job that executes an R notebook, and then inserts the data into the data warehouse.
Does this meet the goal?
Must use an Azure Data Factory, not an Azure Databricks job.
https://docs.microsoft.com/en-US/azure/data-factory/transform-data
Get the complete DP-300 question set
$20$40
Question 4 Domain 3 Monitor, configure, and optimize database resources
You need to recommend a solution that will enable remote developers to access DB1 and DB2. The solution must support the planned changes and meet the secunty requirements.
What should you include in the recommendation?
This question asks for a recommendation to enable remote developers to access DB1 and DB2 securely. Solutions typically include: implementing Azure Virtual Network with service endpoints, configuring firewall rules, using Azure Private Link, enabling Azure AD authentication, or implementing VPN connectivity. The correct recommendation depends on security requirements and planned architecture changes.
Question 5 Domain 1 Plan and implement data platform resources
You plan to deploy an app that includes an Azure SQL database and an Azure web app. The app has the following requirements:
The web app must be hosted on an Azure virtual network.
The Azure SQL database must be assigned a private IP address.
The Azure SQL database must allow connections only from the virtual network.
You need to recommend a solution that meets the requirements.
What should you include in the recommendation?
https://docs.microsoft.com/en-us/azure/azure-sql/database/private-endpoint-overview
Question 6 Domain 5 Plan and configure a high availability and disaster recovery (HA/DR) environment
You have an instance of SQL Server on Azure Virtual Machines.
You need to ensure that a user named User1 can configure proxy accounts for SQL Server Agent jobs. The solution must use the principle of least privilege.
Which role should you assign to User1?
Question 7 Domain 1 Plan and implement data platform resources
You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs
on SQLMI1.
You need to ensure that an automatic email notification is sent once the job completes.
What should you include in the solution?
To send a notification in response to an alert, you must first configure SQL Server Agent to send mail.
Using SQL Server Management Studio; to configure SQL Server Agent to use Database Mail:
In Object Explorer, expand a SQL Server instance.
Right-click SQL Server Agent, and then click Properties.
Click Alert System.
Select Enable Mail Profile.
In the Mail system list, select Database Mail.
In the Mail profile list, select a mail profile for Database Mail.
Restart SQL Server Agent.
Note: Prerequisites include:
Enable Database Mail.
Create a Database Mail account for the SQL Server Agent service account to use.
Create a Database Mail profile for the SQL Server Agent service account to use and add the user to the DatabaseMailUserRole in the msdb database.
Set the profile as the default profile for the msdb database.
https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/configure-sql-server-agent-mail-to-use-database-mail
What the Microsoft DP-300 Exam Covers
Exam domains verified against the Official Microsoft DP-300 exam guide, last checked October 2026.
Domain 1 Plan and implement data platform resources
15% - 20%Plan and deploy Azure SQL solutions including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines. Configure resources for scale and performance, and plan and implement migration strategies from on-premises environments.
Domain 2 Implement a secure environment
20% - 25%Configure database authentication and authorization using Azure AD and SQL logins. Implement encryption for data at rest and in transit, and apply compliance controls for sensitive data including Transparent Data Encryption and Always Encrypted.
Sample question from this domain above Q1
Domain 3 Monitor, configure, and optimize database resources
20% - 25%Monitor resource activity and performance using Azure monitoring tools and Dynamic Management Views. Analyze query execution plans and implement indexing strategies to optimize query performance and overall database health.
Sample question from this domain above Q4
Domain 4 Configure and manage automation of tasks
15% - 20%Create and manage SQL Server Agent jobs for on-premises and Azure environments. Automate deployment of database resources using Infrastructure as Code and configure automated backup and maintenance tasks in Azure.
Domain 5 Plan and configure a high availability and disaster recovery (HA/DR) environment
20% - 25%Design HA/DR strategies based on Recovery Point Objective and Recovery Time Objective requirements. Plan and perform backup and restore operations, and configure failover groups, replication, and geo-redundancy for database solutions.
Sample question from this domain above Q6
DP-300 Exam FAQ
Common questions about the exam itself
Is DP-300 hard and what experience does it assume?
Are there any prerequisites for the DP-300 exam?
Which objective area do candidates find hardest in DP-300?
How long should I study to prepare for DP-300?
What happens on exam day for DP-300?
What are the retake and rescheduling rules for DP-300?
How long does the Azure Database Administrator Associate certification stay valid?
What job role does DP-300 prepare you for?
How does DP-300 relate to other Azure certifications?
What score do I need to pass DP-300?
Other Microsoft Exams
Free practice questions for more Microsoft certification exams