DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ43

Plan and configure a high availability and disaster recovery (HA/DR) environment

You have two SQL Server instances 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 VM1's outbound connections.

Which three actions should you take, in order?

Drag & Drop
Explanation

Certificate-based endpoint authentication requires a database master key in the master database before creating the endpoint certificate. The certificate must also be created in master because the database-mirroring endpoint is a server-scoped endpoint created in master; it can then be configured to use that certificate for outbound authentication.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!