70-465 · Question #110
70-465 Question #110: Real Exam Question with Answer & Explanation
Sign in or unlock 70-465 to reveal the answer and full explanation for question #110. The question stem and answer options stay visible for context.
Question
You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. A server named ABC-SQL1 hosts multiple databases that are accessed using OLTP (Online Transaction Processing) applications. You are concerned about the lack of redundancy provided by this single server solution. You want to configure a solution that ensures high-availability for the databases while minimizing costs. You need to ensure that the databases remain online in the event of a hardware failure of ABC- SQL1. You configure a second server named ABC-SQL2 and install SQL Server 2012. Which of the following solutions would provide the high-availability and enable users to run reports on both copies of the databases?
Options
- AAlwaysOn availability groups
- BA failover cluster
- CDatabase mirroring
- DTransaction log shipping
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.