DRAG DROP
You have a database. The existing backups for the database and their corresponding files are listed in the
following table.
You purchase a new server. You must restore the database to the new server.
You need to restore the data to the most recent time possible.
Which three files should you restore in sequence? To answer, move the appropriate files from the list of files to
the answer area and arrange them in the correct order.
Select and Place:
Explanation:
Step 1: Full..
Start with the full backup.
Step 2: Diff_20160503_1700.bak
Followed by the most recent differential backup.
Step 3: Log_20160503_1900.bak
And finally the most recent log backup (the only log backup done after the most recent differential backup).
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/differential-backups-sqlserver