You administer four SQL Server 2008 instances. Each instance hosts a single database application.
You plan to migrate all four instances to a new SQL Server failover cluster.
The four instances are configured as shown in the following table.
Instance Name Configuration
Instance 1 8 processors that have 16-GB RAM
Instance 2 4 processors that have 8-GB RAM
Instance 3 2 processors that have 16-GB RAM
Instance 4 4 Processors that have 8-GB RAM
The four instances are fully optimized and have no spare CPU cycles or extra memory.
The new cluster will host all four databases on a single virtual cluster IP address.
You need to ensure that the new cluster is configured to handle the workload of all the database applications by using the minimum amount of hardware resources.
Which cluster configuration should you use?
A.
Four-node active/active/active/active cluster that has each node containing a minimum of 9 processors and a 25-GB memory
B.
Two-node active/active cluster that has each node containing a minimum of 9 processors and a 25-GB memory
C.
Two-node active/passive cluster that has each node containing a minimum of 18 processors and a 50-GB memory
D.
Four-node active/active/active/passive cluster that has each node containing a minimum of 18 processors and a 50-GB memory