PrepAway - Latest Free Exam Questions & Answers

What steps should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. ABC.com contains two SQL Server 2008 computers named ABC-DB1 and ABC-DB2.
Both of these computers contain a copy of a database named ABC_DB. You are using
transactional replication between ABC-DB1 and ABC-DB2 for ABC_DB. The backups of the
databases are as follows:
•Full backup is performed nightly.
•Transaction log backups are performed hourly.
Furthermore, replication delay is less than one minute. ABC_DB becomes corrupt on ABC-DB1
and its state was rendered irreparable. You need to return ABC_DB on ABC-DB1 and ensure that
minimal amount of data loss while you copy the data from ABC-DB2 and minimize the impact on
the users of these servers.
What steps should you take? (Each correct option is part of the answer. Choose TWO)

PrepAway - Latest Free Exam Questions & Answers

A.
Detach ABC_DB on ABC-DB2.

B.
Make a transactional backup on ABC-DB1.

C.
Make a differential backup on ABC-DB1.

D.
Make a full backup on ABC-DB1.

E.
Make a transactional backup on ABC-DB2.

F.
Make a differential backup on ABC-DB2.

G.
Make a full backup on ABC-DB2.

H.
Restore the latest transactional backups on ABC-DB1.

I.
Restore the latest differential backup on ABC-DB1.

J.
Restore the latest full backup on ABC-DB1.
K.
Copy the ABC_DB from ABC-DB2 to ABC-DB1.
L.
Copy the ABC_DB from ABC-DB1 to ABC-DB2.
M.
Only one action is required.

Explanation:

First backup the current database from ABC-DB2 by making a full backup. Restore this backup to
replace the corrupt database on ABC-DB1.


Leave a Reply