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

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?

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?

A.
Perform a differential backup at 08:59 hours.

B.
Record the LSN of the transaction log at 08:59 hours. Perform a transaction log backup at 17:01
hours.

C.
Create a database snapshot at 08:59 hours.

D.
Record the LSN of the transaction log at 08:59 hours. Perform a transaction log backup at 08:59
hours.

E.
Create a marked transaction in the transaction log at 08:59 hours. Perform a transaction log
backup at 17:01 hours.

F.
Create a marked transaction in the transaction log at 08:59 hours. Perform a transaction log
backup at 08:59 hours.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Eli

Eli

All options besides (C) involve either Differential or Transaction Log backups, which will be part of a backup chain stretching back the entire week to the previous Sunday when the last Full Backup ran. Hence each of those will take a long time to restore compared with a database snapshot, making (C) the best answer.