Andrew works as a Database Administrator for Miracle Infocom. The company has a SQL server 2005 computer. The computer has a database named Orders. Andrew wants to maintain two copies of the database such that if insert, update, and delete operations are performed on the principal database, it should also apply on the other copy of the database. Which of the following processes will be applied by Andrew to accomplish the task?
A. Failover clustering
B. RAID installation
C. Replication
D. Database mirroring
Answer:D
Andrew works as a Database Administrator for Miracle Infocom. The company has a SQL server 2005 computer. The computer has a database named Orders. Andrew wants to maintain two copies of the database such that if insert, update, and delete operations are performed on the principal database, it should also apply on the other copy of the database. Which of the following processes will be applied by Andrew to accomplish the task?
A. Failover clustering B. RAID installation C. Replication D. Database mirroring