Exam 70-764 topic 1 question 34 discussion

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:

Suggested Answer:
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).
References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/differential-backups-sql-server