DP-300 Certification Practice Question #277

Question

You have two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. VM1 hosts a database named db1.
You plan to create a database availability group (DAG) for db1. The solution must use certificate authentication between VM1 and VM2.
You need to configure authentication for the outbound connections of VM1.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Accepted Answer

To configure certificate-based authentication for outbound connections on `VM1` (part of an Always On Availability Group/mirroring configuration), all steps must be performed in the context of the `master` database. Mirroring endpoints are server-level objects and their authentication certificates must reside in `master` to be accessible globally by the database engine. The correct deployment sequence is: first, create a database master key in the `master` database; second, create the certificate encrypted by that master key; and third, define the server endpoint pointing to that certificate.

More DP-300 practice questions