DRAG DROP
You plan to install two SQL Server 2014 environments named Environment1 and
Environment.
Your company identifies the following availability requirements for each environment:
• Environment1 must have mirroring with automatic failover implemented.
• Environment2 must have AlwaysOn 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.
Answer: 
Environment1 : 3 (Principal, Mirror, Witness)
Environment2 : 2
0
0
one server can play role of witness and either Prin or Mirr
0
0
That’s a freaking lie!! What if the Server playing ”role of witness and principal/mirror” goes down?!
Why do you think a WITNESS is always a requirement for “SQL Server Mirroring w/ Automatic Failover?
0
0
Environment1 : 2
Environment2 : 2
Witness can use PC(SQL EXPRESS), if Question say
“minimum number of SQL Server 2014 servers”
0
0
I think the question is about instances not the “servers”, and the logic of the question is to highlight that alwaysOn is better so 3:2.
0
0
2 and 2. Why anyone would request for 3 if 2 can serve the purpose.
0
0
Env1: 3
because: automatic failover implemented
According to your description, automatic failover is supported only in database mirroring sessions running with a witness in high-safety mode. Be aware that the witness server instance cannot be the same as the principal or mirror server instances. You need to install 3rd instance as a witness server instance, which is not available in every edition of Microsoft SQL Server.
For more information about witness server instance, you can review the following article.
http://technet.microsoft.com/en-us/library/ms188517.aspx
1
0
Exactly my point!!
0
0
I think it is 3 servers for Mirror(principal,Mirror and witness)
and 2 for failover cluster
0
0
Now (201512) in exams question:
1. Environment1 must have mirroring with !!manual!! failover implemented.
be aware
0
0
SW, Thanks for the Tip.
mahikero@yahoo.com
0
0
Mirroring w/Manual Failover can (and should) do with TWO servers.
0
0
3
2
0
0
3
2
0
0