You are mastering the company database called Testing; you should back up the Testing
database fully. You do transaction log once every two hours from 08:00 to 17:00.You should
run database snapshots for the Testing database. You should develop database snapshot
every day at 07:00. At 8:30 the user removes the whole information on the Testing database
which was entered intothe CurrentSpeaker table yesterday. Deletion is the first step for the
database. It is now 11:45 and many other changes have happened in the database. You
should find solution to solve this problem .Which is the correct answer?
A.
You should utilize the SELECT subquery in the INSERT statement to move the deleted
rows from this morning??s database snapshot to the CurrentSpeaker table.
B.
You should utilize the Delete subquery in the INSERT statement to transfer the deleted
rows from yesterday mornings database snapshot to the CurrentSpeaker
C.
You should reserve last nights Full Backup and all transaction log backups until the 10:00
backup. Use the STOP AT statement on the some restores to prevent
D.
You should reserve last nights Full Backup and all transaction log backups until the 10:00
backup. Utilize the STOP AT statement on the last restore to prevent