You are a professional level SQL Sever 2008 Database Administrator. 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.