DP-300 Question #59: Real Exam Question with Answer & Explanation

Sign in or unlock DP-300 to reveal the answer and full explanation for question #59. The question stem and answer options stay visible for context.

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:

Unlock DP-300 to see the answer

You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Unlock DP-300 - $49.99 / 30 days Sign in

Topics

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

Full DP-300 Practice Browse All DP-300 Questions