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 two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.
You need to migrate the databases hosted on SQL 1 to Azure.
The solution must meet the following requirements:
The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections.
Administrative effort must be minimized.
What should you use to host the databases?
- A . a single Azure SQL database
- B . an Azure SQL Database elastic pool
- C . SQL Server on Azure Virtual Machines
- D . Azure SQL Managed Instance
You have an on-premises Microsoft SQL Server 2022 instance that hosts a 60-TB production database named DB1.
You plan to migrate DB1 to Azure.
You need to recommend a hosting solution for DB1.
Which Azure SQL Database service tier should you use to host DB1?
- A . Hyperscale
- B . Business Critical
- C . General Purpose
You have an on-premises Microsoft SQL Server 2022 instance that hosts a 60-TB production database named DB1.
You plan to migrate DB1 to Azure.
You need to recommend a hosting solution for DB1.
Which Azure SQL Database service tier should you use to host DB1?
- A . Hyperscale
- B . Business Critical
- C . General Purpose
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 SQL Server 2019 on an Azure virtual machine.
You are troubleshooting performance issues for a query in a SQL Server instance.
To gather more information, you query sys.dm_exec_requests and discover that the wait type is PAGELATCH_UP and the wait_resource is 2:3:905856.
You need to improve system performance.
Solution: You change the data file for the master database to autogrow by 10 percent.
Does this meet the goal?
- A . Yes
- B . No
HOTSPOT
You have an Azure SQL database.
You are reviewing a slow performing query as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Topic 6, Misc. Questions
You have an Azure SQL database that contains a table named factSales.
FactSales contains the columns shown in the following table.

FactSales has 6 billion rows and is loaded nightly by using a batch process.
Which type of compression provides the greatest space reduction for the database?
- A . page compression
- B . row compression
- C . columnstore compression
- D . columnstore archival compression
You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server
database.
The solution must meet the following requirements:
• Support real-time data replication to a different geographic region.
• Use Azure as a disaster recovery target.
• Minimize costs and administrative effort.
What should you include in the recommendation?
- A . database mirroring on an instance of SQL Server on Azure Virtual Machines
- B . availability groups for SQL Server on Azure Virtual Machines
- C . an Azure SQL Managed Instance link
- D . transactional replication to an Azure SQL Managed Instance
HOTSPOT
You have an Azure subscription that contains a logical SQL server. The server hosts two databases named db1 and db2 and an Azure AD sen/ice principal named appl.
You need to ensure that appl can access db1. The solution must use the principle of least privilege.
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.

HOTSPOT
You have an Azure subscription that contains a logical SQL server. The server hosts two databases named db1 and db2 and an Azure AD sen/ice principal named appl.
You need to ensure that appl can access db1. The solution must use the principle of least privilege.
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 need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements.
What should you create?
- A . a table that has a FOREIGN KEY constraint
- B . a table the has an IDENTITY property
- C . a user-defined SEQUENCE object
- D . a system-versioned temporal table
