DP-300 Certification Practice Question #267

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.
Hot Area:

Accepted Answer

To prepare a database on a secondary replica for an Always On Availability Group, the database must be restored from a backup of the primary database and left in a restoring state so that transaction logs can be forwarded and applied. This is achieved by running the `RESTORE DATABASE` command with the `NORECOVERY` option. Using `RECOVERY` or `STANDBY` would bring the database online or read-only, which makes it ineligible to join the availability group.

More DP-300 practice questions