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.