Microsoft
70-432 · Question #146
70-432 Question #146: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #146. The question stem and answer options stay visible for context.
Question
You are managing two SQL Server 2008 computers called SQLTEST1 and SQTEST2, which include a copy of a database named Sales. The database is replicated between SQL1 and SQL2 by using transactional replication. A full backup of each database is performed every night. Transaction log backups are performed every hour. Replication latency is typically less than two minutes. One afternoon, the Sales database on SQLTEST1 becomes corrupted. You are unable to repair the database. The Sales database on SQLTEST2 is unaffected. You need to return the Sales database on SQLTEST1 to normal operation as quickly as possible. You must ensure a minimum loss of data and minimal impact to users of either server. What should you do?
Options
- AYou should reserve the most recent full database backup and the whole transaction logs
- BYou should reserve only the newest transaction log backup.
- CYou should detach the Sales database on SQL2.
- DYou should reserve a full database backup on SQL2. Reserve the backup to SQL1.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.