70-028 Administering Microsoft SQL Server 7.0 Certification Exam

Microsoft ™

70-028 Administering Microsoft SQL Server 7.0

Note 1: 70-028 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 70-028 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.

Demo Question 11.

The customers table in the Sales database resides on filegroup Sales_FG1. The customerID index on the customers table resides on filegroup sqles_FG2 The hard drive containing Sales_FG1 fails. You need to restore the filegroup from the latest backup. What must you do to restore the customers table in the shortest amount of time?

A. Restore the backup for Sales_FG1, and then load the backup for Sales_FG2
B. Restore the backup for sales_FG1, and then re-create the customerID index on Sales_FG2
C. Back up the transaction log. Restore the backups of sales_FG1 and sales_FG2. Restore all transaction log backups made since the filegroup backups
D. Back up the transaction log. Restore the backups of sales_FG1. Restore all transaction log backups made since the filegroup backups

Display Answer

Purchase Full Version:

70-028 Printable PDF Prep Guide $59.95 BUY NOW!

70-028 Test Simulation Engine $69.95 BUY NOW!

70-028 PDF & Test Simulation Engine $99.95 BUY NOW!

Answer: C.

Explanation: We should start with a transaction log backup to save the latest transactions. We must restore both the table and the corresponding index. They cannot be restored separately. Incorrect