O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide by David W. Tschanz, J. Steven Jones

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

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 ...

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