Free Microsoft DP-300 Exam Questions
Try our Free Demo Practice Tests for Comprehensive DP-300 Exam Preparation
-
Microsoft DP-300 Exam Questions
-
Provided By: Microsoft
- Exam: Administering Microsoft Azure SQL Solutions
- Certification: Microsoft Azure
-
Total Questions: 507
-
Updated On: May 24, 2026
-
Rated: 4.9 |
-
Online Users: 1014
-
Question 1
-
A company wants to implement a high availability and disaster recovery (HA/DR) solution in Azure. They require a maximum of 5 minutes of data loss and a recovery time of 30 minutes. Based on these requirements, which HA/DR solution should they implement?
Answer: B
-
A company wants to implement a high availability and disaster recovery (HA/DR) solution in Azure. They require a maximum of 5 minutes of data loss and a recovery time of 30 minutes. Based on these requirements, which HA/DR solution should they implement?
-
Question 2
-
For a hybrid deployment, you've set up a disaster recovery strategy between on-premises SQL Server and Azure SQL Database. Which of the following is essential to ensure minimal data loss and is supported in this hybrid scenario?
Answer: C
-
For a hybrid deployment, you've set up a disaster recovery strategy between on-premises SQL Server and Azure SQL Database. Which of the following is essential to ensure minimal data loss and is supported in this hybrid scenario?
-
Question 3
-
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII.
You need to record whenever users query the CustomerPII table.
Which two options should you enable? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Answer: B,C
-
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII.
-
Question 4
-
To optimize resource consumption for different types of workloads in Azure SQL Database, what should you configure?
Answer: B
-
To optimize resource consumption for different types of workloads in Azure SQL Database, what should you configure?
-
Question 5
-
You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-
V virtual machines.
Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.
You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment.
What should you include in the recommendation?
Answer: D
-
You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-