Exam 70-462 topic 1 question 9 discussion

Actual exam question from Microsoft's 70-462

Question #: 9
Topic #: 1

DRAG DROP -
You administer three Microsoft SQL Server 2012 servers named ServerA, ServerB, and ServerC.
ServerA is the acting principal and ServerB is the mirror.
You need to add ServerC as a witness to the existing mirroring session between ServerA and ServerB.
You need to achieve this goal without delaying synchronization.
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 Selam at Jan. 31, 2020, 6:46 a.m.

Comments

Submit Cancel

Fame

4 years, 9 months ago

1. On Server C, Create an endpoint for use by the witness 2. Ensure that the same Windows Login exists on each server and grant connect permissions to each Server’s endpoint. 3. On server A, alter the principal database to use the endpoint on the server C as the Witness

upvoted 1 times

...

Fame

4 years, 9 months ago

Reference: https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/add-a-database-mirroring-witness-using-windows-authentication-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15

upvoted 1 times

...

Selam

5 years, 3 months ago

1 , 2, 3, in that order

upvoted 2 times

...

Exam 70-462 All Questions

View all questions & answers for the 70-462 exam

Exam 70-462 topic 1 question 9 discussion

Comments

Fame

Fame

Selam

SY0-701