Microsoft
70-465 · Question #139
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: -
Sign in or unlock 70-465 to reveal the answer and full explanation for question #139. The question stem and answer options stay visible for context.
Submitted by anjalisingh· Mar 5, 2026Implementing SQL Server High Availability and Disaster Recovery Solutions - specifically understanding the minimum infrastructure requirements for mirroring (manual failover) versus AlwaysOn Availability Groups (automatic failover) to ensure data availability during server failures.
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:
Exhibit
Answer Area
Drag items
234
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Database Mirroring#AlwaysOn Availability Groups#High Availability#SQL Server 2012