70-465 · Question #14
You have four databases that are accessed by using an Online Transaction Processing (OLTP) application. The databases are stored on a server named SQL1 that has SQL Server 2014 installed. You plan…
The correct answer is A. AlwaysOn availability groups. The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases…
Question
Options
- AAlwaysOn availability groups
- BDatabase mirroring
- CLog shipping
- DFailover Clustering
How the community answered
(24 responses)- A75% (18)
- B4% (1)
- C8% (2)
- D13% (3)
Explanation
The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise. An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together.
Topics
Community Discussion
No community discussion yet for this question.