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
HOTSPOT
You have an Azure subscription.
You plan to migrate 10 on-premises Microsoft SQL Server instances to Azure.
You need to ensure that the migrated environment can be managed by using multiserver administration and supports master/target (MSX/TSX) jobs. The solution must minimize administrative effort.
Which SQL deployment options should you select as the master server (MSX) and the target server (TSX)? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

SIMULATION
Task 7
You plan to create an automation runbook that will create database users in db1 from Azure AD identities. You need to configure sq1370O6895 to support the creation of new database users.
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.

You have an Azure Data Factory pipeline that performs an incremental load of source data to an Azure Data Lake Storage Gen2 account.
Data to be loaded is identified by a column named LastUpdatedDate in the source table.
You plan to execute the pipeline every four hours.
You need to ensure that the pipeline execution meets the following requirements:
Automatically retries the execution when the pipeline run fails due to concurrency or throttling limits.
Supports backfilling existing data in the table.
Which type of trigger should you use?
- A . tumbling window
- B . on-demand
- C . event
- D . schedule
HOTSPOT
You need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements.
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.

You have an Azure SQL database named DB1.
You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails.
The solution must minimize costs.
Which deployment option and pricing tier should you configure?
- A . Azure SQL Database Hyperscale
- B . Azure SQL Database managed instance General Purpose
- C . Azure SQL Database Premium
- D . Azure SQL Database Basic
You have an Azure subscription.
You create a logical SQL server that hosts four databases Each database will be used by a separate customer.
You need to ensure that each customer can access only its own database. The solution must minimize administrative effort
Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.
- A . Create a network security group (NSG)
- B . Create a server-level firewall rule
- C . Create a private endpoint
- D . Create a database-level firewall rule.
- E . Deny public access.
You are monitoring an Azure Stream Analytics job.
You discover that the Backlogged input Events metric is increasing slowly and is consistently non-zero.
You need to ensure that the job can handle all the events.
What should you do?
- A . Remove any named consumer groups from the connection and use $default.
- B . Change the compatibility level of the Stream Analytics job.
- C . Create an additional output stream for the existing input stream.
- D . Increase the number of streaming units (SUs).
You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server! contains an instance of Microsoft SQL Server 2022 named SQL1 and a database named DB1.
You create a master key in the master database of SQL1.
You need to create an encrypted backup of DB1.
What should you do?
- A . Create a symmetric key in DB1.
- B . Enable visualization-based security (VBS) on Server1.
- C . Create a certificate in DB1.
- D . Create a certificate in the master database of SQL1.
You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server! contains an instance of Microsoft SQL Server 2022 named SQL1 and a database named DB1.
You create a master key in the master database of SQL1.
You need to create an encrypted backup of DB1.
What should you do?
- A . Create a symmetric key in DB1.
- B . Enable visualization-based security (VBS) on Server1.
- C . Create a certificate in DB1.
- D . Create a certificate in the master database of SQL1.
