PrepAway - Latest Free Exam Questions & Answers

What should you do?

The development team of your company creates Microsoft ASP.NET applications by using Microsoft SQL Server 2005. The team uses an application database named AppDB. The production database server is named Server1 and the development database server is named Server2. AppDB is hosted on Server2. You use a System Center Data Protection Manager (DPM) 2007 server to protect Server1 and Server2. This Monday morning, the team reports that a table in AppDB is deleted. The team also reports that the table was present till 16:00 hours last Thursday. You need to recover the table that is missing while AppDB is operational. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Open the DPM Administrator Console and select the first AppDB recovery point that was available till 16:00 hours last Thursday. Select the Rename and recover the database recovery type option. From the recovered database, move the table that is missing to AppDB.

B.
Open the DPM Administrator Console and select the first AppDB recovery point that was available till 16:00 hours last Thursday. Select the Recovery to original instance of SQL Server recovery type option. Verify that the table that is missing is correctly restored in the AppDB database.

C.
Open the DPM Administrator Console and select the first AppDB recovery point that was available till 16:00 hours last Thursday. Select the Copy to a network folder recovery type option and copy the recovered AppDB.mdf file to a local folder on Server2. Rename the AppDB database as AppDB1. Attach the AppDB.mdf file to Server2 and move the table that is missing to AppDB1.Detach AppDB.mdf from Server2 and rename the AppDB1 database as AppDB.

D.
Open the DPM Administrator Console and select the first AppDB recovery point that was available till 16:00 hours last Thursday. Select the Copy to a network folder recovery type option and rename the recovered AppDB.mdf file as AppDB1.mdf. Attach AppDB1.mdf to Server2 and move the table that is missing to AppDB. Detach AppDB1.mdf from Server2.


Leave a Reply