Exam DP-300 topic 7 question 18 discussion

Actual exam question from Microsoft's DP-300

Question #: 18
Topic #: 7

DRAG DROP -
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:

Show Suggested Answer

Suggested Answer:

by Icyb3r at Sept. 5, 2022, 11:50 a.m.

Comments

Submit Cancel

Dalamain

8 months ago

here it is: https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/use-certificates-for-a-database-mirroring-endpoint-transact-sql?view=sql-server-ver16#configuring-outbound-connections

upvoted 4 times

...

voodoo_sh

10 months, 2 weeks ago

master key, certificate, endpoint https://sqlmastersconsulting.com.au/SQL-Server-Blog/configuring-availability-groups-to-use-certificates/

upvoted 3 times

...

vcloudpmp

1 year, 5 months ago

https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/the-database-mirroring-endpoint-sql-server?view=sql-server-ver16

upvoted 1 times

vcloudpmp

1 year, 5 months ago

https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-use-certificates-for-outbound-connections?view=sql-server-ver16

upvoted 1 times

...

vcloudpmp

1 year, 5 months ago

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-master-key-transact-sql?view=sql-server-ver16 The database master key is a symmetric key used to protect the private keys of certificates and asymmetric keys that are present in the database. When it is created, the master key is encrypted by using the AES_256 algorithm and a user-supplied password.

upvoted 1 times

...

Icyb3r

2 years, 3 months ago

Answer is correct.

upvoted 3 times

...