Microsoft
DP-300 · Question #182
Hotspot Question You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 and VM2 each host a default Microsoft SQL Server 2019 instance. VM1 contains a database named D
Sign in or unlock DP-300 to reveal the answer and full explanation for question #182. The question stem and answer options stay visible for context.
Submitted by klara.se· Mar 6, 2026Plan and implement a HADR environment
Question
Hotspot Question You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 and VM2 each host a default Microsoft SQL Server 2019 instance. VM1 contains a database named DB1 that is backed up to a file named D:\DB1.bak. You plan to deploy an Always On availability group that will have the following configurations: - VM1 will host the primary replica of DB1. - VM2 will host a secondary replica of DB1. You need to prepare the secondary database on VM2 for the availability group. How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area. Answer:
Exhibit
Answer Area
- DATABASE MyDB1BACKUPCREATERESTORE
- WITHNORECOVERYRECOVERYSTANDBY
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Always On availability groups#secondary replica#NORECOVERY#T-SQL restore