PrepAway - Latest Free Exam Questions & Answers

What should you include in your solution?

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?

PrepAway - Latest Free Exam Questions & Answers

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

B.
You should include two servers and database mirroring.

C.
You should include two servers and log shipping.

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

One Comment on “What should you include in your solution?


Leave a Reply