70-465 · Question #137
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…
The correct answer is 3; 2. Environment1 requires database mirroring with automatic failover, which mandates a principal server, a mirror server, AND a witness server (3 servers total) - the witness is required to enable automatic failover by providing the quorum needed to promote the mirror. Environment2…
Question
Exhibit
Answer Area
Drag items
Correct arrangement
- 3
- 2
Explanation
Environment1 requires database mirroring with automatic failover, which mandates a principal server, a mirror server, AND a witness server (3 servers total) - the witness is required to enable automatic failover by providing the quorum needed to promote the mirror. Environment2 requires Always On Availability Groups with automatic failover, which needs a minimum of one primary replica and one secondary replica (2 servers), since Always On uses Windows Server Failover Clustering (WSFC) for quorum rather than a dedicated SQL witness server, making 2 SQL Server nodes sufficient for automatic failover.
Topics
Community Discussion
No community discussion yet for this question.