DP-300 Certification Practice Question #213

Question

You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 is 30 TB and has a 1-GB daily rate of change.
You back up the database by using a Microsoft SQL Server Agent job that runs Transact-SQL commands. You perform a weekly full backup on Sunday, daily differential backups at 01:00 in the morning, and transaction log backups every five minutes.
The database fails on Wednesday at 10:00 in the morning.
Which three backups should you restore in sequence? To answer, move the appropriate backups from the list of backups to the answer area and arrange them in the correct order.
Select and Place:

Accepted Answer

To restore DB1 to the point of failure on Wednesday at 10:00 AM, the recovery sequence must start with the most recent full backup (Sunday's **full backup**). Next, because differential backups in SQL Server are cumulative, the **Wednesday differential backup** (taken at 01:00 AM on Wednesday) contains all database changes since Sunday's full backup, rendering Monday's and Tuesday's differential and log backups obsolete. Finally, to recover changes between Wednesday 01:00 AM and the 10:00 AM failure, only the subsequent **Wednesday log backups** must be applied in sequence.

More DP-300 practice questions