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
-
You have SQL Server on Azure virtual machines in an availability group.
You have a database named DB1 that is NOT in the availability group.
You create a full database backup of DB1.
You need to add DB1 to the availability group.
Which restore option should you use on the secondary replica?
Answer: B
-
You have SQL Server on Azure virtual machines in an availability group.
-
Question 2
-
A developer needs to execute a series of database management operations across multiple Azure SQL Databases. Which of the following would be the most suitable to achieve this without managing each database individually?
Answer: C
-
A developer needs to execute a series of database management operations across multiple Azure SQL Databases. Which of the following would be the most suitable to achieve this without managing each database individually?
-
Question 3
-
You have SQL Server on Azure virtual machines in an availability group.
You have a database named DB1 that is NOT in the availability group.
You create a full database backup of DB1.
You need to add DB1 to the availability group.
Which restore option should you use on the secondary replica?
Answer: B
-
You have SQL Server on Azure virtual machines in an availability group.
-
Question 4
-
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 5
-
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.