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: Jan 12, 2026
-
Rated: 4.9 |
-
Online Users: 924
-
Question 1
-
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 2
-
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: A,C
-
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII.
-
Question 3
-
When setting up authentication for your Azure SQL Database, which methods can you use for integrated authentication? (Select all that apply)
Answer: A,B
-
When setting up authentication for your Azure SQL Database, which methods can you use for integrated authentication? (Select all that apply)
-
Question 4
-
You have an Azure SQL database named DB1 that contains a private certificate named Sales. The private key for Sales is encrypted with a password.
You need to change the password for the private key.
Which Transact-SQL statement should you run?
Answer: C
-
You have an Azure SQL database named DB1 that contains a private certificate named Sales. The private key for Sales is encrypted with a password.
-
Question 5
-
You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1.
You need to configure SQL1 to use mixed mode authentication.
Which procedure should you run?
Answer: B
-
You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1.