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

Question

Drag and Drop Question You plan to install two SQL Server 2012 environments named Environment1 and Environment2. Your company identifies the following availability requirements for each environment: - Environment1 must have mirroring with manual failover implemented. - Environment2 must have AlwaysOn with automatic failover implemented. You need to identify the minimum number of SQL Server 2012 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 manual failover, which needs a minimum of 2 servers: one principal and one mirror (a witness is only required for automatic failover, not manual). Environment2 requires AlwaysOn Availability Groups with automatic failover, which also needs a minimum of 2 servers: one primary replica and one secondary replica configured as synchronous-commit with automatic failover - however, AlwaysOn also requires Windows Server Failover Clustering (WSFC), and the automatic failover between replicas can be achieved with just 2 nodes in the availability group. Both environments therefore require a minimum of 2 servers each to maintain data availability if a single physical server fails.

No community discussion yet for this question.