Back to Exams
MicrosoftDP-300
Administering Relational Databases on Microsoft Azure
This certification validates practical ability to design, deploy, and operate scalable cloud services, with emphasis on cloud architecture and operations. It is intended for professionals who manage reliable, secure, and cost-aware environments.
Rate this exam
Exam Details
Total Questions
373Last Updated
Aug. 2026Rating
4.8
Question Types
Multi choices
224Drag&Drop
38Simulation
21Hotspot
90 Get Full Access
Unlimited access to all questions
Detailed explanations for every question
Page progress: 1 / 751%
#1Multiple Choice
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.
#2Drag & Drop
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:
#3Multiple Choice
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. 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?
#4Multiple Choice
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?
#5Multiple Choice
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?