You are a professional level SQL Sever 2008 Database Administrator. Two SQL Server
2008 instances are contained by the site. One is an Enterprise Edition server, and it is on a
server that has a redundant array of independent disks (RAID) 10 disk system The other is
a Standard Edition server, and it is on a server that has a RAID 5 disk system. A single
application is hosted by each instance. A high availability solution should be recommended
for the site to satisfy the business requirements listed below: First, the solution can be
implemented on the current systems. Secondly, the database is available with least
downtime. Thirdly, Data loss should be cut to the least. Fourthly, the existing system should
be with least impact. Which solutions should be utilized to finish the task? (Choose more
than one)
A.
To finish the task, Log shipping should be utilized.
B.
To finish the task, Failover clustering should be utilized.
C.
To finish the task, Replication should be utilized.
D.
To finish the task, Database snapshot should be utilized.