You are a database administrator for AIOTestKing.com. The company has a SQL Server 2005 computer that contains a single user database named DB1. All company employees connect to DB1. Company policy requires that the database be fault-tolerant and that failovers require no administrative effort. You need to provide fault tolerance for the database. Your solution must ensure that client computers can connect to the database, even if the SQL Server 2005 computer experiences a complete hardware failure, including a failure of all disks. What should you do?
A.
Implement transactional replication to another SQL Server 2005 computer.
B.
Implement database mirroring to another SQL Server 2005 computer.
C.
Implement a two-node server cluster that contains the database.
D.
Implement log shipping to another SQL Server 2005 computer.