nerdexam
CompTIA

SG0-001 · Question #282

Which three (3) backup methods support application recovery of a database? (Choose three.)

The correct answer is A. Use software snapshot technology that takes a point in time snapshot. B. Cold backup method where the database services have been stopped before the backup. C. Copy-on-Write technology built into the database that can be used by backup software.. Database application recovery relies on backup methods that ensure data consistency, which can be achieved through mechanisms like consistent snapshots, offline backups, or database-aware copy-on-write solutions.

Storage Functionality

Question

Which three (3) backup methods support application recovery of a database? (Choose three.)

Options

  • AUse software snapshot technology that takes a point in time snapshot.
  • BCold backup method where the database services have been stopped before the backup.
  • CCopy-on-Write technology built into the database that can be used by backup software.
  • DFile system backup method including transaction log needed to run the backup and restore.
  • ECopy the database folder to another location and back up the files in the normal fashion.

How the community answered

(39 responses)
  • A
    92% (36)
  • D
    5% (2)
  • E
    3% (1)

Why each option

Database application recovery relies on backup methods that ensure data consistency, which can be achieved through mechanisms like consistent snapshots, offline backups, or database-aware copy-on-write solutions.

AUse software snapshot technology that takes a point in time snapshot.Correct

Software snapshot technology, such as Volume Shadow Copy Service (VSS) or database-specific snapshot features, creates a point-in-time consistent copy of the database files, allowing for reliable restoration and application recovery without requiring the database to be offline for extended periods.

BCold backup method where the database services have been stopped before the backup.Correct

A cold backup method involves stopping database services before the backup, which guarantees that all database files are in a consistent state without any in-flight transactions or open files, making it a highly reliable method for database recovery.

CCopy-on-Write technology built into the database that can be used by backup software.Correct

Copy-on-Write (CoW) technology, whether implemented at the database level or by the underlying storage, creates an instantaneous, consistent copy of the database data as it existed at the moment the copy began, even while the database remains active, thereby supporting application recovery.

DFile system backup method including transaction log needed to run the backup and restore.

A generic file system backup of an active database's files, even with transaction logs, often results in an inconsistent state because files might be open, partially written, or in an unstable condition, making reliable application recovery difficult or impossible without specific database-aware backup tools.

ECopy the database folder to another location and back up the files in the normal fashion.

Simply copying an active database folder and its files to another location will likely result in an inconsistent backup, as database files are constantly being updated, and a simple file copy does not guarantee a transactionally consistent state required for reliable database application recovery.

Concept tested: Database backup and recovery methods

Source: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-overview-sql-server?view=sql-server-ver16

Topics

#Database backup#Application recovery#Snapshots#Cold backup

Community Discussion

No community discussion yet for this question.

Full SG0-001 Practice