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. SQL Server 2008 servers on a single site are managed by
you. 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.