You administer a SQL Server 2008 infrastructure. An instance runs on a computer that has eight quad-core processors and 128-GB RAM. Four different applications use the instance. The instance…

Question

Options

• AConfigure the Resource Governor.
• BConfigure the Windows System Resource Manager.
• CConfigure software non-uniform memory access (soft-NUMA).
• DConfigure an increase in the maximum degree of parallelism option.

• A
  3% (1)
• B
  13% (4)
• C
  78% (25)
• D
  6% (2)

Explanation

Failover clustering in SQL Server provides high--availability support for an entire SQL Server instance. For example, you can configure a SQL Server instance on one node of a failover cluster to fail over to any other node in the cluster during a hardware failure, operating system failure, or a planned upgrade. A failover cluster is a combination of one or more nodes (servers) with two or more shared disks, known as a resource group. The combination of a resource group, along with its network name, and an internet protocol (IP) address that makes up the clustered application or server, is referred to as a failover cluster or a failover cluster instance. A SQL Server failover cluster appears on the network as if it were a single computer, but has functionality that provides failover from one node to another if the current node becomes unavailable. A failover cluster appears on the network as a normal application or single computer, but it has additional functionality that increases its Failover clustering has a new architecture and new work flow for all Setup scenarios in SQL Server 2008. The two options for installation are Integrated installation and AdvancedlEnterprise installation. Integrated installation creates and configures a single-node SQL Server failover cluster instance. Additional nodes are added using add node functionality in Setup. For example, for Integrated installation, you run Setup to create a single-node failover cluster. Then, you run Setup again for each node you want to add to the cluster. AdvancedlEnterprise installation consists of two steps. The Prepare step prepares all nodes of the failover cluster to be operational. Nodes are defined and prepared during this initial step. After you prepare the nodes, the Complete step is run on the active nods--the node that owns the shared disk--to complete the failover cluster instance and make it operational. When to Use Failover Clustering Use failover clustering to: - Administer a failover cluster from any node in the clustered SQL Server configuration. For more information, see Installing a SQL Server 2008 Failover Cluster. - Allow one failover cluster node to fail over to any other node in the failover cluster configuration. For more information, see Installing a SQL Server 2008 Failover Cluster. - Configure Analysis Services for failover clustering. For more information, see How to: install Analysis Services on a failover cluster. - Execute full-text queries by using the Microsoft Search segilce with failover clustering. For more information, see Using SQL Server Tools with Failover stering.

No community discussion yet for this question.