YOU HAVE A SQL SERVER 2008 INSTALLATION, AND YOU WANT TO CREATE A...

20. You have a SQL Server 2008 installation, and you want to create a high-

availability solution. What are the ideal approach(es) to solve this problem?

A. Backup and restore

B. Replication

C. Mirroring

D. Clustering

The correct answers are C and D. C and D are automated high-availability

solutions. Answer A is not necessarily a good solution as it is not automated.

Answer B will create a copy of a database, but will require intervention in

order for the replicated database to become the active database.