You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security,troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you.
A business-critical database is hosted by the instance, and the database must be constantly available to the
users with no data loss. Filestream data is contained by the database.
A high-availability solution should be designed for the site.
Which solution should be utilized?
A.
Database snapshot should be utilized.
B.
Failover clustering should be utilized.
C.
Asynchronous database mirroring should be utilized.
D.
Synchronous database mirroring with a witness server should be utilized.