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. In SQL Server 2008 database mirroring, what is the role of the WITNESS server?

    Answer: It monitors the principal and mirror and enables automatic failover

    The witness server participates in quorum voting and enables automatic failover by detecting when the principal is unavailable and promoting the mirror.

  2. Which SQL Server 2008 backup option allows you to continue taking a backup even if the source database has suspect pages?

    Answer: WITH CONTINUE_AFTER_ERROR

    WITH CONTINUE_AFTER_ERROR instructs the backup to continue even if errors such as suspect pages are encountered, recording errors in the backup header.

  3. You need to capture all T-SQL statements executed against a database for auditing. Which is the MOST efficient method in SQL Server 2008?

    Answer: Create a SQL Server Audit with a Database Audit Specification for EXECUTE events

    SQL Server Audit with a Database Audit Specification provides granular, low-overhead auditing of specific event types compared to C2 auditing or full traces.

  4. What does the 'torn page detection' database option help detect in SQL Server 2008?

    Answer: Incomplete 8KB page writes caused by power failure during I/O

    Torn page detection stores a bit pattern in each 512-byte sector of a page and checks it on read to detect incomplete writes caused by power or hardware failure.

  5. A SQL Server 2008 Agent job fails intermittently. Where should you look FIRST to diagnose the failure?

    Answer: SQL Server Agent job history in SSMS

    The SQL Server Agent job history in SSMS provides step-level output messages and return codes, making it the fastest first stop for diagnosing job failures.

  6. Which SQL Server 2008 feature allows you to redirect connections to a different server automatically when the primary fails, requiring only a virtual network name change in the connection string?

    Answer: SQL Server Failover Clustering

    SQL Server Failover Clustering uses a virtual network name (VNN) that clients connect to, and Windows Server Failover Clustering automatically moves the SQL resource to a surviving node.

  7. You need to shrink a transaction log file that has grown unexpectedly large. After backing up the log, which command should you use?

    Answer: DBCC SHRINKFILE with the log file name

    DBCC SHRINKFILE targeting the log file name releases unused virtual log files (VLFs) after a log backup has truncated the inactive portion of the log.