nerdexam
Microsoft

70-450 · Question #82

70-450 Question #82: Real Exam Question with Answer & Explanation

The correct answer is B. Two-node active/passive cluster should be utilized and a minimum of 18 processors and a. To-use the least amount of hardware resources, we will create a single two nodes Active-Passive As all the instances should be able to run without impact, we will sum the number of CPU; here it is 18 CPU for each node Memory needed: 18 GB + 8 GB + 16 GB + 8 GB = 48 GB + 2 GB for

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

Explanation

To-use the least amount of hardware resources, we will create a single two nodes Active-Passive As all the instances should be able to run without impact, we will sum the number of CPU; here it is 18 CPU for each node Memory needed: 18 GB + 8 GB + 16 GB + 8 GB = 48 GB + 2 GB for the OS = 50 GB.

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-450 Practice