Exam Prep Questions


1.

An error has occurred that has corrupted one of the databases on the server. The database is set to full recovery, the last full backup occurred last night, and log backups have been continuing on an hourly basis throughout the day. No differential backups are currently performed. What steps do you need to take to get the database up and running again with the least loss of data? (Choose all that apply.)

  • A. Restore the last full backup.

  • B. Restore the last differential backup.

  • C. Restore logs from the last full or differential backup.

  • D. Restore logs from the last full or differential backup by using STOPAT.

  • E. Perform a log backup.

  • F. Perform a differential backup.

  • G. Perform a full backup.

2.

You are creating a database backup schedule for all system and user databases. You would like to perform nightly full backups and hourly log backups for all these databases. What must you do to accomplish this? (Choose all that apply.)

  • A. Ensure that no databases are set to simple recovery.

  • B. Ensure that all databases are set to simple recovery.

  • C. Exclude the master, model, and msdb databases from the log backups.

  • D. Exclude the master database from the log backups.

  • E. Exclude the model and msdb database from the log backups.

3.

You have a tape that contains the copy of a backup. You want to verify that the data has not been corrupted. What do you do? (Choose the best answer.)

  • A. Use the RESTORE statement with the VERIFYONLY option.

  • B. Use the BACKUP statement with the VERIFYONLY option.

  • C. Use the RESTORE statement with the CHECKSUM option.

  • D. Use the BACKUP statement with the CHECKSUM option.

  • E. This cannot be done. Verification has to occur at the time of the backup.

4.

You have found a backup tape that has been created on another server. The tape was not labeled, and you would like to determine its contents. You want to find out which backup sets are on the tape. How do you perform this task? (Choose the appropriate answer.)

  • A. Use RESTORE VERIFYONLY.

  • B. Use RESTORE HEADERONLY.

  • C. Use RESTORE LABELONLY.

  • D. You must access this information from the originating server.

5.

You have just created and scheduled the maintenance plans for your company. You have created many jobs and schedules. You would like to back up these plans so that they can be recovered, if needed. What is the easiest method of performing this task? (Choose the appropriate answer.)

  • A. Back up the master database.

  • B. Back up all user databases.

  • C. Back up the msdb database.

  • D. Create scripts for all jobs and schedules.

6.

You would like to confirm that one of your scheduled jobs was successful. You do not have access to a SQL Server Management Studio installation, but you can run queries and stored procedures against the server. What is the easiest technique for finding the information? (Choose the appropriate answer.)

  • A. Run a query against the master..sysobjects table.

  • B. Run a query to join the msdb..sysjobs and msdb..sysjobhistory tables.

  • C. Run a query against the msdb..sysschedules table.

  • D. Run a query by using sp_help_jobhistory.

7.

You would like to use log shipping and want to start the process by using a full backup and the most recent log backup from the source database. How do you get these backups onto the destination and implement the configuration and query? (Select all that apply.)

  • A. Restore the full backup, using RECOVERY.

  • B. Restore the full backup, using NORECOVERY.

  • C. Restore the full backup, using STANDBY.

  • D. Restore the log backup, using RECOVERY.

  • E. Restore the log backup, using NORECOVERY.

  • F. Restore the log backup, using STANDBY.




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net