Incorrect: A majority node set cluster with only two nodes does not provide any fault tolerance.

Correct: You can configure a two-node standard cluster for the external-facing databases, as well as a separate two-node standard cluster for all internal databases. This technology provides automated failover capabilities while also meeting the availability requirements.

Incorrect: You can configure database mirroring for automated failover, but the ASP and ColdFusion applications cannot take advantage of the transparent client redirect capability and thus require you to reconfigure them to point to the mirror database.

Correct: Replication is needed to move data from the external-facing databases into a database inside the firewall so that marketing can perform its analysis.

Incorrect: Failover clustering maintains only a single copy of the data and cannot be used to move data from the external databases inside the firewall for the marketing department.

Incorrect: Database mirroring can send the customer- and order-related data from the external databases to a SQL Server instance inside the firewall, but the mirror databases are inaccessible to users.

Incorrect: Log shipping can be used to maintain a copy of data in which it can be accessed by marketing, but there is a lag time in the data. All users would have to be kicked out of the database before a restore operation could be executed.

Correct: You can use replication to move data from the external databases inside the firewall and maintain the data in near real time, and it does not require all users to be out of the database to apply changes.

Correct: Margie’s Travel needs to configure two servers to provide automatic failover capability for the databases supporting the Web applications. Two servers also have to be configured to provide automatic failover for the databases supporting internal applications. Windows Server 2003 Standard Edition with SQL Server 2008 Standard supports a two-node cluster as well as database mirroring, at the lowest cost of all the options.

Incorrect: Margie’s Travel needs to configure two servers to provide automatic failover capability for the databases supporting the Web applications. Two servers also have to be configured to provide automatic failover for the databases supporting internal applications. Windows Server 2003 Enterprise Edition with SQL Server 2008 Standard supports a two-node cluster as well as database mirroring, but at a higher cost than Windows Server 2003 Standard Edition.

Incorrect: Margie’s Travel needs to configure two servers to provide automatic failover capability for the databases supporting the Web applications. Two servers also have to be configured to provide automatic failover for the databases supporting internal applications. Windows Server 2003 Enterprise Edition with SQL Server 2008 Enterprise supports a two-node cluster as well as database mirroring, but at a higher cost than Windows Server 2003 Standard Edition.

Incorrect: Margie’s Travel needs to configure two servers to provide automatic failover capability for the databases supporting the Web applications. Two servers also have to be configured to provide automatic failover for the databases supporting internal applications. Windows Server 2003 Datacenter Edition with SQL Server 2008 Datacenter supports a two-node cluster as well as database mirroring, but at a higher cost than Windows Server 2003 Standard Edition.