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.
Four SQL Server 2008 instances are managed by you. And 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?
A.
Four-node active/active/active/active cluster should be utilized and a minimum of 9 processors and a 25-GB memory are contained by each node.
B.
Two-node active/passive cluster should be utilized and a minimum of 18 processors and a 50-GB memory are contained by each node.
C.
Two-node active/active cluster should be utilized and a minimum of 9 processors and a 25-GB memory are contained by each node.
D.
Four-node active/active/active/passive cluster should be utilized and a minimum of 18 processors and a 50-GB memory are contained by each node.