Backup Types for Database Servers

SK0-005 By islever Editorial Last updated

Short answer

D Open file

Question

Which of the following backup types should be chosen for database servers?
  1. Differential
  2. Incremental
  3. Synthetic full
  4. Open file Correct Answer

Key Takeaways

The exam tests the distinction between general backup types (Full, Differential, Incremental) and specialized techniques required for active databases, with the trap being the assumption that differential or synthetic methods are primary choices.

This question tests knowledge of backup methodologies specifically optimized for live database environments. The community consensus and official answer favor 'Open file' backups to ensure data consistency without halting operations.

Common mistake: Candidates often choose Differential or Synthetic Full because they optimize storage or restore times, failing to recognize that these do not inherently solve the issue of locking open database files during the backup process.

Expert Analysis

Why the Answer Is Correct

Open file backup (also known as hot backup or application-consistent backup) is the correct choice because it allows data to be copied while the database engine keeps the files open and actively writing transactions. This method relies on Volume Shadow Copy Service (VSS) or similar APIs to capture a consistent snapshot of the database state at a specific point in time, ensuring integrity without requiring downtime.

Why the Other Options Are Wrong

Differential, Incremental, and Synthetic full backups describe how much data is backed up relative to previous backups, but they do not specify how the data is accessed. If you run a standard differential backup on an open database file without an open-file mechanism, you risk capturing corrupted or inconsistent data due to ongoing writes. Therefore, 'Open file' is the critical enabling feature for database servers.

Community Comment Notes

Comment [1] correctly notes that CompTIA's Server+ Student Guide explicitly highlights Open file backups for their benefit to databases. Comment [4] reinforces this by explaining that open file backups allow data capture while files are in use. While Comment [2] suggests AI tools might incorrectly favor Differential, the exam logic prioritizes the specific capability of handling open handles over backup frequency strategies.

Exam Strategy

When asked about 'database' or 'live server' backups, look for options related to consistency mechanisms like 'Open file', 'Hot backup', or 'Snapshot'. Prioritize the method that ensures data integrity during active I/O over methods that merely reduce storage space.

Community Votes

D
67%
C
33%

67% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 4 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 4

  1. kx7tg4xu 👍 1 Answered C
    C. Synthetic full Synthetic full backups combine data from a full backup with incremental or differential backups to create a “full backup” without actually reacquiring the full backup. This method reduces disk writes and network load while creating a data set similar to a full backup. Synthetic full backups are suitable for database backups because they must conserve system resources while maintaining the data from the full backup. It does not require the actual acquisition of a full backup, and can efficiently maintain a full backup using incremental or differential data, which is less likely to impact performance on a production database server.
  2. Stache 👍 1 Answered D
    Open file (D) specifically addresses the benefit is brings to databases in CompTIA's Server+ Student Guide, while it's mentioned zero on the other methods.
  3. Ronn_Burgandy 👍 1 Answered D
    Open file backup will allow for data to be backed up even while the file open which is perfect for databases that are constantly in use.
  4. ompk 👍 1
    chatgpt and google chooses Differential back up for database servers

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Dual Power Supplies on Different Sources: Fault Tolerance vs Redundancy

S-grade

Mitigating Brute-Force Attacks: Password Policy Priority

S-grade

SAN Connectivity Issue: No Link Lights on HBA and Switch

S-grade

Mitigating Server Virus Infection and Vulnerability

A-grade

Practice All SK0-005 Questions

Access 135 questions with complete answers and detailed explanations.

View Full SK0-005 Practice Test →

← Back to SK0-005 Study Guide