70-465 Question #137: Real Exam Question with Answer & Explanation

Question

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. Answer:

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.

No community discussion yet for this question.