Which is the BEST solution?

You need to design a high availability strategy to guarantee database access in an event of server failure and
minimize data storage utilization. Which is the BEST solution?

You need to design a high availability strategy to guarantee database access in an event of server failure and
minimize data storage utilization. Which is the BEST solution?

A.
Database Mirror

B.
AlwaysOn availability groups

C.
Clustered SQL Server instances

D.
Log shipping

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

Muraru Adrian

Muraru Adrian

C. is the right answer.
Clustered instances are protected only for “server failures”. Unfortunately, shared storage is a point of failure, due to is not protected by solution.
Storage is shared on cluster nodes (visible/accessible only on active node), so condition “minimize data storage utilization” is met.

On A., B., D. each server has own storage volumes, so condition for minimizing storage is not met.

Reply