nerdexam
Microsoft

DP-300 · Question #59

Drag and Drop 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…

The correct answer is full backup; Wednesday differential backup; Wednesday log backups. To restore a SQL Server database, you always start with the most recent full backup (Sunday's), then apply the most recent differential backup (Wednesday's, which encompasses all changes since Sunday including Monday and Tuesday), and finally apply the transaction log backups…

Submitted by obi.ng· Mar 6, 2026Implement and manage database backup and recovery strategies on Azure SQL infrastructure, including understanding the correct sequence for restoring full, differential, and transaction log backups in SQL Server disaster recovery scenarios.

Question

Drag and Drop 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. Answer:

Exhibit

DP-300 question #59 exhibit

Answer Area

Drag items

Monday, Tuesday, and then Wednesday differential backupsWednesday, Tuesday, and then Monday log backupsfull backupMonday, Tuesday, and then Wednesday log backupsWednesday, Tuesday, and then Monday differential backupsWednesday log backupsWednesday differential backup

Correct arrangement

  • full backup
  • Wednesday differential backup
  • Wednesday log backups

Explanation

To restore a SQL Server database, you always start with the most recent full backup (Sunday's), then apply the most recent differential backup (Wednesday's, which encompasses all changes since Sunday including Monday and Tuesday), and finally apply the transaction log backups from Wednesday up to the point of failure at 10:00 AM. The Wednesday differential backup already includes all changes from Monday and Tuesday since Sunday's full backup, so you only need one differential - not multiple daily differentials - before replaying the transaction logs.

Topics

#SQL Server Backup and Restore#Differential Backup#Transaction Log Backup#Azure Virtual Machines

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice