O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Review Questions

  1. You are a database administrator for your company. Your company has two offices located in Cuzco, 50 kilometers (31 miles) from each other connected by a 100Mb WAN. You need to design a fault-tolerant SQL Server 2005 database solution so that if a server crashes in one office, the solution will automatically failover to the other office. What high-availability technology should you use?
    1. Clustering
    2. Merge replication
    3. Log shipping
    4. Transactional replication
  2. You are a database administrator for your company responsible for a database solution running on a SQL Server 2005 instance. The database consists of a primary, secondary, and log file, all of which are stored on three separate drives. The database is using the SIMPLE recovery ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required