Practice Test Geeks(MCTS) Microsoft Certified Technology Specialist Practice Test
← All MCTS Flashcard Decks

SQL Server 2008 Administration Flashcards

7 cards from real MCTS practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 SQL Server 2008 Administration flashcards as text

  1. You have a database with a FULL recovery model. After a tail-log backup fails due to log file corruption, what is the correct restore sequence?

    Answer: Restore full backup, then all differential backups, then all log backups in order

    In FULL recovery, you must restore the full backup, then the latest differential, then all subsequent log backups in sequence to reach the desired recovery point.

  2. What does the NORECOVERY option do when used in a RESTORE statement?

    Answer: It leaves the database in a restoring state so additional backups can be applied

    NORECOVERY leaves the database in a restoring/standby state, allowing additional differential or log backups to be applied before bringing the database online.

  3. Which SQL Server 2008 feature allows a secondary database to receive transaction log backups from a primary and be used for read-only reporting?

    Answer: Log Shipping

    Log Shipping automatically sends transaction log backups to one or more secondary servers, which can be configured in STANDBY mode for read-only access.

  4. A SQL Server instance is experiencing high PAGEIOLATCH_SH waits. What is the MOST likely root cause?

    Answer: Disk I/O bottleneck causing slow page reads from storage

    PAGEIOLATCH_SH waits indicate threads are waiting to read data pages from disk into the buffer pool, pointing to an I/O subsystem bottleneck.

  5. You need to move a user database to a new drive without taking it offline for long. Which technique minimizes downtime?

    Answer: Use backup and restore to the new location

    Backup and restore to the new location with MOVE option allows you to redirect data and log files, minimizing the time the database is unavailable.

  6. What is the maximum number of CPUs that SQL Server 2008 Standard Edition supports?

    Answer: 4

    SQL Server 2008 Standard Edition supports up to 4 CPU sockets, making it suitable for smaller workloads compared to Enterprise Edition.

  7. Which DBCC command is used to check the logical and physical integrity of all objects in a SQL Server database?

    Answer: DBCC CHECKDB

    DBCC CHECKDB validates the allocation structures, catalog integrity, and checks every table and indexed view in the specified database.