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.
Question
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)- A61% (14)
- C26% (6)
- D13% (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.
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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.