Administering Relational Databases on Microsoft Azure

Here you have the best Microsoft DP-300 practice exam questions

  • You have 373 total questions across 75 pages (5 per page)
  • These questions were last updated on February 16, 2026
  • This site is not affiliated with or endorsed by Microsoft.
Question 1 of 373
You have 20 Azure SQL databases provisioned by using the vCore purchasing model.
You plan to create an Azure SQL Database elastic pool and add the 20 databases.
Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Answer

Suggested Answer

The suggested answer is A, C, E.

When sizing an Azure SQL Database elastic pool, it is essential to consider several key metrics. First, the total size of all the databases is crucial, as it determines the storage requirements for the pool. Second, the number of concurrently peaking databases multiplied by the peak CPU utilization per database is important to assess the maximum computational demand. Lastly, the total number of databases multiplied by the average CPU utilization per database helps in gauging the average computational load. These three metrics together provide a comprehensive understanding of the necessary resources to meet the demands of the workload effectively. Therefore, total size of all the databases, number of concurrently peaking databases * peak CPU utilization per database, and total number of databases * average CPU utilization per database are the correct metrics to use.

Community Votes8 votes
ACESuggested
100%
Question 2 of 373
DRAG DROP -
You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database.
A recent failure causes the master database to be lost.
You discover that all Microsoft SQL Server integration Services (SSIS) packages fail to run on the virtual machine.
Which four actions should you perform in sequence to resolve the issue? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct.
Select and Place:
Exam DP-300: Question 2 - Image 1
Answer

Suggested Answer

Step 1: Attach the SSISDB database
Step 2: Turn on the TRUSTWORTHY property and the CLR property
If you are restoring the SSISDB database to an SQL Server instance where the SSISDB catalog was never created, enable common language runtime (clr)
Step 3: Open the master key for the SSISDB database
Restore the master key by this method if you have the original password that was used to create SSISDB. open master key decryption by password = 'LS1Setup!' --'Password used when creating SSISDB'
Alter Master Key Add encryption by Service Master Key
Step 4: Encrypt a copy of the master key by using the service master key
Reference:
https://docs.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog Exam DP-300: Question 2 - Image 2
Question 3 of 373
You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table.
Exam DP-300: Question 3 - Image 1
FactSales has 6 billion rows and is loaded nightly by using a batch process. You must provide the greatest reduction in space for the database and maximize performance.
Which type of compression provides the greatest space reduction for the database?
Answer

Suggested Answer

The suggested answer is C.

Columnstore compression is the correct choice because it offers significant space reduction while also ensuring optimal performance for queries. While columnstore archival compression provides even greater space reduction, it compromises performance, which is not ideal given the requirement to maximize performance. Traditional row or page compression techniques do not achieve the same level of compression or performance improvements as columnstore compression.

Community Votes22 votes
DMost voted
68%
CSuggested
32%
Question 4 of 373
You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features.
✑ Clustered columnstore indexes
✑ Automatic tuning
✑ Change tracking
✑ PolyBase
You plan to migrate DB1 to an Azure SQL database.
What feature should be removed or replaced before DB1 can be migrated?
Answer

Suggested Answer

The suggested answer is B.

PolyBase is a feature in SQL Server used for querying data from external data sources like Hadoop or Azure Blob Storage. However, Azure SQL Database does not support most PolyBase features, and this could hinder the migration process. Therefore, PolyBase should be removed or replaced before migrating the database to an Azure SQL database.

Community Votes13 votes
BSuggested
100%
Question 5 of 373
You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.
You plan to migrate DB1 to an Azure SQL Database managed instance.
What should you use to minimize downtime and data loss during the migration?
Answer

Suggested Answer

The suggested answer is D.

To minimize downtime and data loss during the migration of a 4-TB database to an Azure SQL Database managed instance, Azure Database Migration Service is the most suitable option. This service supports online migrations, which limit downtime to the duration of the cutover at the end of the migration, thus ensuring minimal disruption to the application and reduced data loss.

Community Votes4 votes
DSuggested
100%

About the Microsoft DP-300 Certification Exam

About the Exam

The Microsoft DP-300 (Administering Relational Databases on Microsoft Azure) validates your knowledge and skills. Passing demonstrates proficiency and can boost your career prospects in the field.

How to Prepare

Work through all 373 practice questions across 75 pages. Focus on understanding the reasoning behind each answer rather than memorizing responses to be ready for any variation on the real exam.

Why Practice Exams?

Practice exams help you familiarize yourself with the question format, manage your time, and reduce anxiety on the test day. Our DP-300 questions are regularly updated to reflect the latest exam objectives.