Backup Types for Database Servers

Infrastructure Management

Which of the following backup types should be chosen for database servers?

  1. Differential
  2. Incremental
  3. Synthetic full
  4. Open file Source Reference Answer

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.

Community Insight

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.

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.

Community Discussion (4 comments)

Stache 👍 1 Selected: 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.
ompk 👍 1
chatgpt and google chooses Differential back up for database servers
kx7tg4xu 👍 1 Selected: 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.
Ronn_Burgandy 👍 1 Selected: 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.

Comments & Corrections

No comments 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.

Submitted for moderation before publishing. Keep it helpful and respectful.

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.

Official Reference

https://www.comptia.org/contentguides/server-plus-sk0-005-content-guide

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.

Related Analysis

A server located in an IDF of a paper mill reboots every oth

A-Grade

A company is implementing a check-in desk to heighten physic

A-Grade

A server administrator is configuring a new server in a data

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