Assessment Test

  1. Which high-availability technologies support automatic failover? (Choose all that apply.)
    1. Failover clustering
    2. Database mirroring
    3. Log shipping
    4. Replication

    Answer: A, B. Only failover clustering and database mirroring support automatic failover in the event of a disaster. Log shipping and replication require manual intervention. See Chapter 10 for more information.

  2. You are looking to consolidate your SQL Server instances onto one large SQL Server 2005 server. Which of the following should you consider when determining which instances you can consolidate? (Choose all that apply.)
    1. Database names
    2. CPU and memory utilization
    3. Number of logins on each instance
    4. Reallocation of existing resources

    Answer: A, B, D. When choosing to consolidate ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.