DRAG DROP
You have a test server that contains a database named DB1. Backups of the database are written to a single
backup device. The backup device has a full, differential, and transaction log backup.
You discover that the database is damaged. You restore the database to the point at which the differential
backup was taken.
You need to rebuild the database with data stored in the latest transaction logs.
How should you complete the Transact-SQL statement? To answer. drag the appropriate Transact-SQL
segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at
all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:
Answer: 
Explanation:
Box 1: RESTORE
Box 2: RECOVERY
The RESTORE … WITH RECOVERY option puts the database into a useable state, so users can access a
restored database.
https://www.mssqltips.com/sqlservertutorial/112/recovering-a-database-that-is-in-the-restoringstate/
After the word RESTORE either the word DATABASE or LOG should follow. So in this case the answer should be RESTORE LOG DB1… in my opinion.
5
0
This answer is incorrect the file extension .bak if for differential backup on which you need to leave in the non recovery state since tail log “.trn” will be still re-installed last with recovery.
0
0
You restore the database to the point at which the differential
backup was taken.
You need to rebuild the database with data stored in the latest transaction logs.–> so the tsql is
Restore log db1 from…. With recovery
0
0
The file extension bak or trn does not matter it could be xxx or whatever
1
0
Maybe they choose RESTORE only because there is no RESTORE LOG from the options, if you choose RESTORE DATABASE that is incorrect nearest is restore only.
0
0
You are right.. It is hard the exam if i need to choose not between rigth and wrong but the nearest to the right
0
0
Restore with NoRecovery
or
Restore Log with Recovery (inexistent option)
2
0