70-465 Question #91: Real Exam Question with Answer & Explanation

Question

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).

Options

• ATake a full backup of the database before deploying the changes.
• BTake a copy-only backup of the database before deploying the changes.
• CTake a snapshot of the database before deploying the changes.
• DRestore the database from the backup.
• ERestore the snapshot to another server and recover the required objects from the snapshot.
• FRevert the database to the snapshot.