Exam SY0-601 topic 1 question 612 discussion

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

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.

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

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.

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.

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.

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.