You are a professional level SQL Sever 2008 Database Administrator. A business-critical database is hosted by the instance, and the database must be constantly available to the users with no data…

Question

Options

• ADatabase snapshot should be utilized.
• BFailover clustering should be utilized.
• CAsynchronous database mirroring should be utilized.
• DSynchronous database mirroring with a witness server should be utilized.

• A
  7% (4)
• B
  73% (40)
• C
  18% (10)
• D
  2% (1)

Explanation

Failover clustering in SQL Server provides high--avaiIability 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 lallover cluster lnstance. A SOL 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 Advancedllinterprise 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 node--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 Sewer configuration. For more information, see Installing a SOL 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 service with failover clustering. For more information, see Using SQL Server Tools with Failover Clustering.

No community discussion yet for this question.