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 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 App1 as soon as possible, without considering immediate costs.
What should you do?
- A . Increase the number Of vCores allocated to db1.
- B . Disable auto-pause delay for dbl.
- C . Decrease the auto-pause delay for db1.
- D . Enable automatic tuning for db1.
You need to trigger an Azure Data Factory pipeline when a file arrives in an Azure Data Lake Storage Gen2 container.
Which resource provider should you enable?
- A . Microsoft.EventHub
- B . Microsoft.EventGrid
- C . Microsoft.Sql
- D . Microsoft.Automation
You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.
You scale up the virtual machine to 16 vCPUSs and 64 GB of memory.
You need to provide the lowest latency for tempdb.
What is the total number of data files that tempdb should contain?
- A . 2
- B . 4
- C . 8
- D . 64
What should you implement to meet the disaster recovery requirements for the PaaS solution?
- A . Availability Zones
- B . failover groups
- C . Always On availability groups
- D . geo-replication
You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1.
You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on-premises network connects to VNET1 by using an ExpressRoute connection.
You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service.
You need to configure VNET1 to support the migration.
What should you do?
- A . Configure service endpoints.
- B . Configure virtual network peering.
- C . Deploy an Azure firewall.
- D . Configure network security groups (NSGs).
You are evaluating the business goals.
Which feature should you use to provide customers with the required level of access based on their service agreement?
- A . dynamic data masking
- B . Conditional Access in Azure
- C . service principals
- D . row-level security (RLS)
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?
- A . database mirroring
- B . distributed availability groups
- C . Always On Availability Group
- D . Azure Database Migration Service
You plan to move two 100-GB databases to Azure.
You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations.
What should you use?
- A . two Azure SQL Databases in an elastic pool
- B . two databases hosted in SQL Server on an Azure virtual machine
- C . two databases in an Azure SQL Managed instance
- D . two single Azure SQL databases
You manage 100 Azure SQL managed instances located across 10 Azure regions.
You need to receive voice message notifications when a maintenance event affects any of the 10 regions. The solution must minimize administrative effort.
What should you do?
- A . From the Azure portal, create a service health alert.
- B . From the Azure portal, create an Azure Advisor operational excellence alert.
- C . From Microsoft SQL Server Management Studio (SSMS), configure a SQL Server agent job.
- D . From the Azure portal, configure an activity log alert.
You have an Azure SQL managed instance.
You need to enable SQL Agent Job email notifications.
What should you do?
- A . Use the Agent XPs option.
- B . Enable the SQL Server Agent.
- C . Run the sp_configure command.
- D . Run the sp set_agent properties command.