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.
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)- A92% (36)
- D5% (2)
- E3% (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.
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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.