You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You have a database named CorpDB.
A full backup of CorpDB is taken every week.
A differential backup of CorpDB is taken every night at midnight.
A transaction log backup of CorpDB is taken at 8am, 12pm, 4pm and 8pm.
You plan to deploy some changes to CorpDB at after the 4pm log backup completes. You
need to ensure that you can undo the changes quickly if the deployment fails. During the
deployment of the changes, no other changes must be made by users to the database.
You need a backup and recovery strategy for deploying the changes.
Which two of the following actions would meet the backup and recovery requirements
whilst ensuring the regular backup schedule is not disrupted? (Choose two).
A.
Take a full backup of the database before deploying the changes.
B.
Take a copy-only backup of the database before deploying the changes.
C.
Take a snapshot of the database before deploying the changes.
D.
Restore the database from the backup.
E.
Restore the snapshot to another server and recover the required objects from the snapshot.
F.
Revert the database to the snapshot.
Explanation:
http://msdn.microsoft.com/en-us/library/ms175158.aspx
So, what right answer, do you think?
Database snapshots are copies of the database up to the point it was created, since no use will be allowed to change anything, you can use it as a safeguard, then run you script(s), and if it fails revert the database using its snapshot, so the correct answer is C and F.