Microsoft
70-465 · Question #1
Drag and Drop Question You need to recommend a backup process for an Online Transaction Processing (OLTP) database. The process must meet the following requirements: - Ensure that if a hardware failur
Sign in or unlock 70-465 to reveal the answer and full explanation for question #1. The question stem and answer options stay visible for context.
Submitted by emma.c· Mar 5, 2026Design and Implement a High Availability and Disaster Recovery Solution for SQL Server / Database Administration
Question
Drag and Drop Question You need to recommend a backup process for an Online Transaction Processing (OLTP) database. The process must meet the following requirements: - Ensure that if a hardware failure occurs, you can bring the database online with a minimum amount of data loss. - Minimize the amount of administrative effort required to restore any lost data. What should you include in the recommendation? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Answer:
Exhibit
Answer Area
Drag items
Create a database snapshot.Perform a differential backup of the database every night.Ship the logs to a secondary server.Perform a backup of the transaction log every hour.Set the database to the simple recovery model.Set the database to the full recovery model.Perform a weekly full backup of the database.
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 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.
Topics
#SQL Server Backup and Recovery#OLTP High Availability#Log Shipping#Recovery Models