A company has limited storage space available and an online presence that cannot be down for more than four hours. Which of the following backup methodologies should the company implement to allow for the FASTEST database restore time in the event of a failure, while being mindful of the limited available storage space?
To achieve the fastest database restore time while being mindful of limited available storage space, the company should implement full backups every Sunday at 8:00 p.m. and nightly differential backups at 8:00 p.m. Full backups ensure that there is a complete snapshot of the database once a week. Differential backups, which capture all changes since the last full backup, reduce the amount of time needed for restoration compared to incremental backups, as restoration would involve applying only the last differential backup to the full backup. This strikes a balance between quick recovery time and efficient use of storage space.
Changing to D D. Implement full backups every Sunday at 8:00 p.m. and nightly differential backups at 8:00 p.m. With this option, you have the most recent state of the database captured in the differential backup, which can be restored relatively quickly. The nightly differential backups minimize data loss compared to incremental backups. This approach strikes a balance between minimizing downtime and conserving storage space.
full backup is needed. but we also need differential or incremental, otherwise, we lost data from Sunday to certain workday. then choice between differential or incremental is really the restore time. incremental need every copy of the previous day's until Sunday's to restore; while differential is just difference between that day and sunday. So differential will be faster.
Then "C" would be the fastest restore time.
Do we need to have an incremental or differential backup? It we do only full backups nightly can we restore with just that full backup? The C could be the fastest restore time.
Explanation: Full backups every Sunday provide a complete snapshot of the database, ensuring that all data is backed up. This ensures that in the event of a failure, the most recent complete dataset is available for restoration. Nightly differential backups capture all changes made since the last full backup, which allows for faster restoration compared to incremental backups. Differential backups require less storage space compared to full backups and provide faster restore times compared to incremental backups. This combination ensures that the company has the most recent complete backup available on Sundays and captures all changes efficiently during the week, minimizing the time required for restoration while conserving storage space.
Option D strikes a balance between backup speed and storage space by performing a full backup once a week and differential backups every night. This ensures that all data is captured at least once a week, while minimizing the amount of data that needs to be backed up each night. In the event of a failure, the company can restore from the most recent full backup and the most recent differential backup, which should provide a relatively fast restore time.
They do not care about the data as much as they care about the FASTEST way and the limited storage. So it's certainly a full back-up a week
D is the best answer
D makes the most sense.
D. Implement full backups every Sunday at 8:00 p.m. and nightly differential backups at 8:00 p.m.
I think the answer is A. This is the only answer which mentions TAPE backup, others not. As the storage space is limited for the company, the data should be backed up on a TAPE, and not in a file, which occupies storage space. It is also mentioned that the FASTEST restore type is needed, so forget about full+differential or full+incrementals, if simple full is also an option. It is not mentioned in the question that the most recent backup data is an important requirement, so a 1 week old full is the fastest.
B - incremental backups produces the smallest data size
yeah but its the slowest to restore
you cant perform incremental and differential without a full backup. B doesn't even make sense.
B. Implement differential backups every Sunday at 8:00 p.m. and nightly incremental backups at 8:00 p.m. Here's why this option is the most suitable choice: Differential backups taken every Sunday capture all changes made to the database since the last full backup (which is on Sunday). These backups are relatively larger than incremental backups but smaller than full backups. They provide a good balance between backup size and restore time. Nightly incremental backups at 8:00 p.m. capture only the changes made since the last backup (whether it's a full or differential backup). Incremental backups are smaller and faster to create compared to full or differential backups.
Can't be compared with the combo Full + Incr. Differential backups need a lot more space,
I think C as it wants the FASTEST (FULL Backups) while also being mindful of limited space. Adding any other backup solution on top of the Full Backup will use more space.
It wants the FASTEST restore... which is only achievable with a Full Backup + only the latest Differential since the last Full Backup was taken. So, even if you take Differential Backup everyday of the week, you only need the latest Differential + the Last Full Backup before that, for restoration & full data recovery.