nerdexam
Microsoft

70-450 · Question #77

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…

The correct answer is A. To finish the task, Log shipping should be utilized. C. To finish the task, Replication should be utilized. Failover clustering is not possible, because the two system are not on the same array of disk and furthermore, you have to implement it on the current system. Database snapshot is not one HA solution, because it is stored on the same server. Replication and Log shipping are…

Design an optimized high availability and disaster recovery solution

Question

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)

Options

  • ATo finish the task, Log shipping should be utilized.
  • BTo finish the task, Failover clustering should be utilized.
  • CTo finish the task, Replication should be utilized.
  • DTo finish the task, Database snapshot should be utilized.

How the community answered

(63 responses)
  • A
    84% (53)
  • B
    11% (7)
  • D
    5% (3)

Explanation

Failover clustering is not possible, because the two system are not on the same array of disk and furthermore, you have to implement it on the current system. Database snapshot is not one HA solution, because it is stored on the same server. Replication and Log shipping are both answering to the four requirements.

Topics

#log shipping#replication#high availability#edition constraints

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-450 Practice