70-332 · Question #60
You need to meet the technical requirements for failover. What should you do?
The correct answer is B. Configure an AlwaysOn availability group between PROD-DB-01 and PROD-DB-02. SQL Server AlwaysOn availability groups provide automatic failover, readable secondaries, and support for multiple replicas - making them the correct high-availability solution for SQL Server 2012 and later.
Question
Exhibit
Options
- AConfigure log shipping between PROD-DB-01 and PROD-DB-02.
- BConfigure an AlwaysOn availability group between PROD-DB-01 and PROD-DB-02.
- CConfigure database mirroring with an additional witness server between PROD-DB-01 and PROD-DB-02.
- DConfigure an active/passive failover cluster between PROD-DB-01 and PROD-DB-02.
How the community answered
(49 responses)- A10% (5)
- B84% (41)
- C2% (1)
- D4% (2)
Why each option
SQL Server AlwaysOn availability groups provide automatic failover, readable secondaries, and support for multiple replicas - making them the correct high-availability solution for SQL Server 2012 and later.
Log shipping is a disaster recovery technique with inherent latency and requires manual intervention to promote the secondary, so it does not meet automatic failover requirements.
AlwaysOn availability groups support automatic failover between primary and secondary replicas with near-zero data loss using synchronous commit mode. They also support readable secondary replicas and multiple failover targets, satisfying modern HA requirements. This feature replaced older technologies like mirroring starting in SQL Server 2012.
Database mirroring was deprecated in SQL Server 2012 and does not support readable secondaries or multiple replicas, making it inferior to AlwaysOn for failover requirements.
An active/passive failover cluster instance (FCI) protects against node failure but relies on shared storage, creating a single point of failure at the storage layer and providing no readable secondary.
Concept tested: SQL Server AlwaysOn availability group failover configuration
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.