PrepAway - Latest Free Exam Questions & Answers

You work as a Database Administrator (DBA) at ABC.com. The infrastructure includes servers running Microsoft S

You work as a Database Administrator (DBA) at ABC.com. The infrastructure includes servers running Microsoft SQL Server 2012. All databases

are hosted on a SAN (Storage Area Network).

You need to design a database solution for a new application.

You are tasked with designing a high-availability database solution.

The solution must include a single copy of the database to save disk space and

the database must remain online in the event of a SQL Server failure. What should you include in your solution?

A. You should include two servers configured as a failover cluster.

B. You should include two servers and database mirroring.

C. You should in

clude two servers and log shipping.

D. You should include two servers configure as a SQL Server Availability Group


Leave a Reply