nerdexam
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…

The correct answer is Create a database snapshot.; Set the database to the full recovery model.; Ship the logs to a secondary server.; Perform a weekly full backup of the database.; Set the database to the simple recovery model.; Perform a differential backup of the database every night.; Perform a backup of the transaction log every hour. For an OLTP database requiring minimal data loss and minimal administrative effort for restoration, the correct sequence is: Create a database snapshot (baseline point-in-time reference), Set the database to the full recovery model (enables transaction log backups and…

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

70-465 question #1 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.

Correct arrangement

  • Create a database snapshot.
  • Set the database to the full recovery model.
  • Ship the logs to a secondary server.
  • Perform a weekly full backup of the database.
  • Set the database to the simple recovery model.
  • Perform a differential backup of the database every night.
  • Perform a backup of the transaction log every hour.

Explanation

For an OLTP database requiring minimal data loss and minimal administrative effort for restoration, the correct sequence is: Create a database snapshot (baseline point-in-time reference), Set the database to the full recovery model (enables transaction log backups and point-in-time recovery, unlike Simple model which truncates logs), Ship the logs to a secondary server (automatically forwards transaction logs to a standby server, minimizing data loss on hardware failure with minimal admin overhead). Log shipping satisfies both requirements simultaneously - it automates the process and keeps a warm standby current within the log shipping interval, meaning hardware failure recovery is fast and data loss is minimized.

Topics

#SQL Server Backup and Recovery#OLTP High Availability#Log Shipping#Recovery Models

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-465 Practice