Your network consists of one Active Directory domain. All domain controllers run Windows Server
2008. You need to prepare the environment to provide a high-availability solution for a back-end
Microsoft SQL Server 2005 data store. What should you do?
A.
Install a Windows Server 2003 Network Load Balancing cluster.
B.
Install a Windows Server 2008 Network Load Balancing cluster.
C.
Install a Windows Server 2008 failover cluster that has shared storage.
D.
Install a Windows Server 2008 failover cluster that has direct attached storage.
Explanation:
To ensure the high availability of the data store, you need to use Windows Server 2008 failover
cluster having a shared storage. Failover clustering can help you build redundancy into your network
and eliminate single points of failure. Administrators have better control and can achieve better
performance with storage than was possible in previous releases. Failover clusters now support
GUID partition table (GPT) disks that can have capacities of larger than 2 terabytes, for increased
disk size and robustness. Administrators can now modify resource dependencies while resources are
online, which means they can make an additional disk available without interrupting access to the
application that will use it. And administrators can run tools in Maintenance Mode to check, fix, back
up, or restore disks more easily and with less disruption to the cluster. You should not use Network
Load Balancing (NLB) because it only allows you to distribute TCP/IP requests to multiple systems in
order to optimize resource utilization, decrease computing time, and ensure system availability.
High Availability
http://www.microsoft.com/windowsserver2008/en/us/high-availability.aspx