Microsoft DP-300 Practice Exams
Last updated on Nov 16,2026- Exam Code: DP-300
- Exam Name: Administering Microsoft Azure SQL Solutions
- Certification Provider: Microsoft
- Latest update: Nov 16,2026
You have an Azure SQL database named DB1. You run a query while connected to DB1.
You review the actual execution plan for the query, and you add an index to a table referenced by the query.
You need to compare the previous actual execution plan for the query to the Live Query Statistics.
What should you do first in Microsoft SQL Server Management Studio (SSMS)?
- A . For DB1, set QUERY_CAPTURE_MODE of Query Store to All.
- B . Run the SET SHOWPLAN_ALL Transact-SQL statement.
- C . Save the actual execution plan.
- D . Enable Query Store for DB1.
You have an Azure subscription that contains the resources shown in the following table.

You need to configure a connection between VM1 and MIL.
The solution must meet the following requirements:
• The connection must be encrypted.
• Network latency must be minimized.
What should you implement?
- A . virtual network peering
- B . private endpoints
- C . service endpoints
- D . a site-to-site VPN
You have an Azure subscription that contains the following resources:
• 10 Azure SQL databases
• Five Azure SQL managed instances
• Five instances of SQL Server on Azure Virtual Machines
You need to implement a centralized monitoring solution for all the Azure SQL resources. The solution must minimize administrative effort.
What should you include in the solution?
- A . Log Analytics
- B . Azure SQL Analytics
- C . Query Performance Insight
- D . SQL Insights
Which counter should you monitor for real-time processing to meet the technical requirements?
- A . SU% Utilization
- B . CPU% utilization
- C . Concurrent users
- D . Data Conversion Errors
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 Synapse Analytics dedicated SQL pool that contains a table named Table1.
You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1.
You plan to insert data from the files into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1.
You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1.
Solution: You use an Azure Synapse Analytics serverless SQL pool to create an external table that has an additional DateTime column.
Does this meet the goal?
- A . Yes
- B . No
You have SQL Server 2019 or an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.
Vou scale up the virtual machine to 8 vCPUs and 64 GB of memory.
You need to reduce tempdb contention without regatively affecting server performance.
What is the number of secondary data files that you should configure for tempdb?
- A . 2
- B . 4
- C . 8
- D . 64
HOTSPOT
You have an Azure subscription.
You plan to deploy an Azure SQL database by using an Azure Resource Manager template.
How should you complete the template? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

HOTSPOT
You have an Azure SQL database named db1 on a server named server1.
You use Query Performance Insight to monitor db1.
You need to modify the Query Store configuration to ensure that performance monitoring data is available as soon as possible.
Which configuration setting should you modify and which value should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You have a new Azure SQL database. The database contains a column that stores confidential information.
You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed.
Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Turn on auditing and write audit logs to an Azure Storage account.
- B . Add extended properties to the column.
- C . Turn on Advanced Data Security for the Azure SQL server.
- D . Apply sensitivity labels named Highly Confidential to the column.
- E . Turn on Azure Advanced Threat Protection (ATP).
DRAG DROP
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.



