You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run on Windows Server2003 and all client computers run Windows XP Professional. The Domain.com network contains two SQL Server 2005 database servers that are configured in a cluster with two nodes named NodeA and NodeB.
NodeA contains two physical hard disk drives, one of which hosts the Quorum resource and contains a single partition while the other contains two logical partitions. NodeB also has two physical hard disk drives each of which contain a single logical partition. None of the hard disks in the cluster have any unallocated space left. The SQL Server 2005 cluster currently hosts four database instances. Domain.com wants to implement another SQL Server 2005 instance for a database named Manufacturing_DB. Manufacturing_DB will store data from the Domain.com Manufacturing department. You have been instructed to create the SQL Server 2005 instance for the Manufacturing_DB database.
What should you do?
A.
Run the SQL Server 2005 Setup utility on NodeB and select a Named Instance for the Manufacturing_DB database.
B.
Create a second logical partition on one of the physical disk drives on NodeB. Run the SQL Server 2005 Setup utility on NodeB and select a Named Instance for the Manufacturing_DB database.
C.
Add a third physical disk drive on one of the nodes. Run the SQL Server 2005 Setup utility on that node and select Named Instance for the Manufacturing_DB database.
D.
Run the SQL Server 2005 Setup utility on NodeA and select a Named Instance for the Manufacturing_DB database.
Explanation:
A single SQL Server 2005 database server can host up to 50 instances but a clustered SQL Server 2005 configuration can only host one instance per logical disk drive. There are currently five logical disk drives in the cluster but one is used for the Quorum resource this leaves you with four logical disk drives that can support a total of four instances. To add another instance, you would need to add another logical disk drive. As none of the hard disks have unallocated free space, you would need to add another hard disk to the cluster.
Incorrect Answers:
A, D: You cannot add another instance to any of the two nodes as a clustered SQL Server 2005 configuration can only host one instance per logical disk drive. There are currently five logical disk drives in the cluster but one is used for the Quorum resource this leaves you with four logical disk drives that can support a total of four instances. To add another instance, you would need to add another logical disk drive. As none of the hard disks have unallocated free space, you would need to add another hard disk to the cluster.
B: You cannot create another partition on any of the physical drives on NodeB as none of the hard disks in the cluster has unallocated free space that you can use to create another partition. You will need to add another hard disk to the cluster for the new instance.