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