Free Microsoft DP-300 Exam Questions
Absolute Free DP-300 Exam Practice for Comprehensive Preparation
-
Microsoft DP-300 Exam Questions
-
Provided By: Microsoft
- Exam: Administering Microsoft Azure SQL Solutions
- Certification: Microsoft Azure
-
Total Questions: 462
-
Updated On: Nov 24, 2025
-
Rated: 4.9 |
-
Online Users: 924
-
Question 1
-
You receive numerous alerts from Azure Monitor for an Azure SQL Database instance.
You need to reduce the number of alerts. You must only receive alerts if there is a significant change in usage patterns for an extended period.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Answer: B,D
-
You receive numerous alerts from Azure Monitor for an Azure SQL Database instance.
-
Question 2
-
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.
You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.
You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
✑ Ensure that all traffic to the public endpoint of SqlSrv1 is blocked.
✑ Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.
What should you create on VNet1?
Answer: C
-
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.
-
Question 3
-
You want to deploy multiple Azure resources as a unit. Which of the following would you primarily use to define and deploy those resources? (Select the best answer)
Answer: C
-
You want to deploy multiple Azure resources as a unit. Which of the following would you primarily use to define and deploy those resources? (Select the best answer)
-
Question 4
-
Your organization wants to deploy a SQL Server HA/DR solution in Azure. They have the following requirements:
Automatic failover without manual intervention.
Read and write operations should be possible on the primary replica, while only read operations should be allowed on the secondary replica.
Both primary and secondary replicas must reside in different Azure regions for disaster recovery purposes.
Which of the following configurations meets all the provided requirements?
Answer: A
-
Your organization wants to deploy a SQL Server HA/DR solution in Azure. They have the following requirements:
-
Question 5
-
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1.
You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.
Solution: You restore the backup for Database1 from Server1 to the Server2 by using the RESTORE Transact-SQL command with the REPLACE option.
Does this meet the goal?
Answer: A
-
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.