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 Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1.
You plan to create a database named DB1 in Pool1.
You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless SQL pool.
Which format should you use for the tables in DB1?
- A . JSON
- B . CSV
- C . Parquet
- D . ORC
You have an Azure subscription that contains the resources shown in the following table.

App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity.
You need to modify db1 to resolve the issues experienced by Appl as soon as possible, without considering immediate costs
What you do?
- A . Increase the number of vCores allocated to db1.
- B . Decrease the auto-pause delay for db1.
- C . Disable auto-pause delay for db1.
- D . Enable automatic tuning for db1.
HOTSPOT
You have an Azure SQL database named DB 1 in the General Purpose service tier.
You need to monitor DB 1 by using SQL Insights.
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.

HOTSPOT
You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1.
You need to protect the contents of Column1 at rest, in transit, and in use.
How should you protect the contents of Column1? 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 that contains an Azure Active Directory (Azure AD) user named user1.
You need to test impersonation of user1 in db1 by running a SELECT statement and returning to the original execution context.
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.

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?
- A . RuntheDBCC SQLPERF command.
- B . Run the dbcc dbreindex command.
- C . Modify the automatic tuning settings for db1.
- D . Modify the Query Store settings for db1.
You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2.
You need to limit the number of IOPs that App2 queries generate on SQL1.
Which two actions should you perform on SQL1? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Enable query optimizer fixes.
- B . Enable Resource Governor.
- C . Enable parameter sniffing.
- D . Create a workload group.
- E . Configure In-memory OLTP.
- F . Run the Database Engine Tuning Advisor.
- G . Reduce the Max Degree of Parallelism value.
You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2.
You need to limit the number of IOPs that App2 queries generate on SQL1.
Which two actions should you perform on SQL1? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Enable query optimizer fixes.
- B . Enable Resource Governor.
- C . Enable parameter sniffing.
- D . Create a workload group.
- E . Configure In-memory OLTP.
- F . Run the Database Engine Tuning Advisor.
- G . Reduce the Max Degree of Parallelism value.
You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1. You need to move a SQL Server Agent job from DB1 to SQLMI1.
Which job attribute is unsupported in SQLMI1?
- A . log to table
- B . email notifications
- C . schedules
- D . output files
You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1. You need to move a SQL Server Agent job from DB1 to SQLMI1.
Which job attribute is unsupported in SQLMI1?
- A . log to table
- B . email notifications
- C . schedules
- D . output files