Microsoft
70-457 · Question #130
70-457 Question #130: Real Exam Question with Answer & Explanation
Sign in or unlock 70-457 to reveal the answer and full explanation for question #130. The question stem and answer options stay visible for context.
Question
You administer a Microsoft SQL Server 2012 instance named SQL2012 that hosts an OLTP database of 1 terabyte in size. The database is modified by users only from Monday through Friday from 09:00 hours to 17:00 hours. Users modify more than 30 percent of the data in the database during the week. Backups are performed as shown in the following schedule: The Finance department plans to execute a batch process every Saturday at 09:00 hours. This batch process will take a maximum of 8 hours to complete. The batch process will update three tables that are 10 GB in size. The batch process will update these tables multiple times. When the batch process completes, the Finance department runs a report to find out whether the batch process has completed correctly. You need to ensure that if the Finance department disapproves the batch process, the batch operation can be rolled back in the minimum amount of time. What should you do on Saturday?
Exhibit
Options
- APerform a differential backup at 08:59 hours.
- BRecord the LSN of the transaction log at 08:59 hours.
- CCreate a database snapshot at 08:59 hours.
- DRecord the LSN of the transaction log at 08:59 hours.
- ECreate a marked transaction in the transaction log at 08:59 hours.
- FCreate a marked transaction in the transaction log at 08:59 hours.
Unlock 70-457 to see the answer
You've previewed enough free 70-457 questions. Unlock 70-457 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.