nerdexam
Microsoft

70-450 · Question #82

You are a professional level SQL Sever 2008 Database Administrator. They are respectively named Ins01, Ins02, Ins03 and Ins04. A single database application is hosted by each instance. All four…

Sign in or unlock 70-450 to reveal the answer and full explanation for question #82. The question stem and answer options stay visible for context.

Design an optimized high availability and disaster recovery solution

Question

You are a professional level SQL Sever 2008 Database Administrator. They are respectively named Ins01, Ins02, Ins03 and Ins04. A single database application is hosted by each instance. All four instances should be removed to a new SQL Server failover cluster. You can see the configuration of the four instances from the table listed below:

All the four instances are sufficiently optimized, and there are no spare CPU cycles or extra memory in the instances. All four databases will be hosted by the new cluster on a single virtual cluster IP address. Since you are the technical support, you are required to set the new cluster to handle the workload of all the database applications with the least amount of hardware resources. From the four cluster configuration, which one should be utilized?

Exhibit

70-450 question #82 exhibit

Options

  • AFour-node active/active/active/active cluster should be utilized and a minimum of 9 processors
  • BTwo-node active/passive cluster should be utilized and a minimum of 18 processors and a
  • CTwo-node active/active cluster should be utilized and a minimum of 9 processors and a 25-GB
  • DFour-node active/active/active/passive cluster should be utilized and a minimum of 18

Unlock 70-450 to see the answer

You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#failover clustering#active/passive cluster#hardware sizing#cluster topology
Full 70-450 Practice