nerdexam
Microsoft

70-465 · Question #84

You need to plan the SQL Server 2012 deployment that meets the design requirements. Which of the following steps should you perform? (Choose all that apply)

The correct answer is A. Upgrade the existing SQL Server 2005 server to SQL Server 2012. B. Install one new server running SQL Server 2012. E. Configure AllwaysOn. This question tests knowledge of SQL Server 2012 high availability deployment using AlwaysOn Availability Groups, which requires upgrading existing instances and adding a secondary replica node.

Submitted by neha2k· Mar 5, 2026Design and implement database solutions for SQL Server

Question

You need to plan the SQL Server 2012 deployment that meets the design requirements. Which of the following steps should you perform? (Choose all that apply)

Options

  • AUpgrade the existing SQL Server 2005 server to SQL Server 2012.
  • BInstall one new server running SQL Server 2012.
  • CInstall two new servers running SQL Server 2012
  • DConfigure Failover Clustering
  • EConfigure AllwaysOn

How the community answered

(23 responses)
  • A
    61% (14)
  • C
    26% (6)
  • D
    13% (3)

Why each option

This question tests knowledge of SQL Server 2012 high availability deployment using AlwaysOn Availability Groups, which requires upgrading existing instances and adding a secondary replica node.

AUpgrade the existing SQL Server 2005 server to SQL Server 2012.Correct

Upgrading the existing SQL Server 2005 instance to SQL Server 2012 is required because AlwaysOn Availability Groups are only supported on SQL Server 2012 and later, and the existing server must participate in the new availability group configuration.

BInstall one new server running SQL Server 2012.Correct

Installing one new server running SQL Server 2012 is necessary to serve as the secondary replica in an AlwaysOn Availability Group, providing high availability and readable secondary functionality without requiring a full cluster shared storage model.

CInstall two new servers running SQL Server 2012

Installing two new servers is unnecessary because AlwaysOn Availability Groups require only one additional secondary replica node alongside the upgraded primary, making a second new server redundant and outside the stated design requirements.

DConfigure Failover Clustering

Failover Clustering (Windows Server Failover Clustering for SQL Server FCI) requires shared storage and is a different high availability model than AlwaysOn Availability Groups; the design requirements call for AlwaysOn, not a traditional failover cluster instance.

EConfigure AllwaysOnCorrect

AlwaysOn Availability Groups is the correct high availability solution in SQL Server 2012 that provides database-level failover, readable secondaries, and does not require shared storage, making it the appropriate choice for meeting modern HA design requirements.

Concept tested: SQL Server 2012 AlwaysOn Availability Groups deployment planning

Source: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server

Topics

#SQL Server deployment#AlwaysOn Availability Groups#Failover Clustering#High availability

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice