CompTIA Cloud Essentials+ (CLO-002)Management and Technical OperationsMedium
A cloud operations team needs to restore a critical database to a point in time within the last 24 hours. The database is hosted on a virtual machine, and the organization has a policy for daily full backups and hourly incremental backups. Which backup strategy is MOST likely to meet this requirement efficiently?
- ACreating a new database and manually importing the most recent data.
- BRestoring from the latest full backup, then applying all subsequent incremental backups.
- CRestoring from the latest full backup only.
- DRestoring from a snapshot taken just before the incident.
Show answer & explanationAnswer & explanation
Correct answer: B. Restoring from the latest full backup, then applying all subsequent incremental backups.
To achieve a point-in-time recovery with daily full and hourly incremental backups, you must first restore the latest full backup and then apply all relevant incremental backups in sequence up to the desired point in time. This ensures data integrity and minimizes data loss.
Why the other options are wrong
- A. Manual import is inefficient and error-prone for a critical database restoration, especially for point-in-time recovery.
- C. Restoring only the full backup would result in significant data loss (up to 24 hours).
- D. Snapshots capture the entire state at a single moment; while effective, the question describes a daily full and hourly incremental strategy, implying a need to combine them for point-in-time recovery.
Point-in-Time Recovery
The ability to restore data to a specific, desired moment in time, often achieved by combining a full backup with subsequent incremental or differential backups.
- Minimizes data loss by restoring to a very specific point.
- Requires both a base backup and a sequence of changes.
- Crucial for transactional databases.
Memory trick: Full + Incremental = Perfect Time Restore.