Exam 70-764 topic 1 question 264 discussion

Actual exam question from Microsoft's 70-764

Question #: 264
Topic #: 1

DRAG DROP -
You plan to install two SQL Server 2014 environments named Environment1 and Environment2. Your company identifies the following availability requirements for each environment:
✑ Environment1 must have mirroring with automatic failover implemented.
✑ Environment2 must have Always On with automatic failover implemented.
You need to identify the minimum number of SQL Server 2014 servers that must be deployed to each environment to ensure that all data remains available if a physical server fails.
How many servers should you identify? To answer, drag the appropriate number to the correct environment in the answer area.
Select and Place:

Show Suggested Answer

Suggested Answer:

by TheSwedishGuy at Jan. 31, 2020, 5:36 p.m.

Comments

Submit Cancel

Tabz

5 years, 3 months ago

The witness in AlwaysOn can be a file share and you dont need a separate node running SQL Server hence 3 and 2 are the correct answers

upvoted 2 times

...

TheSwedishGuy

5 years, 5 months ago

Mirroring: High-safety mode with automatic failover requires a third server instance, known as a witness. If the mirror is in manual failover mode, only two servers is required.

upvoted 1 times

...

TheSwedishGuy

5 years, 5 months ago

What about the server which is the witness? Shouldn't they both require 3 servers?

upvoted 1 times

Iva10

5 years, 4 months ago

There is no withnes in AlwaysAvailability group, 2 is enough

upvoted 3 times

...