Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam SY0-501 topic 1 question 42 discussion

Actual exam question from CompTIA's SY0-501
Question #: 42
Topic #: 1
[All SY0-501 Questions]

A database backup schedule consists of weekly full backups performed on Saturday at 12:00 a.m. and daily differential backups also performed at 12:00 a.m. If the database is restored on Tuesday afternoon, which of the following is the number of individual backups that would need to be applied to complete the database recovery?

  • A. 1
  • B. 2
  • C. 3
  • D. 4
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
macshild
Highly Voted 4 years, 4 months ago
guys there are 3 kinds of backups a full backup which backs everything up , an incremental backup which backs that have been saved on the pc for that day , and if done again the next day it will again only back up the things that have been saved on the pc for that day. and finally there is the differential backup which will back up all the files that have been modified or saved since the last full back up so if you do a full backup on Sunday , and you do a differential backup on Monday the differential back will backup everything on the computer that was modified(edited, deleted or whatever) in addition to new things that was saved on the computer from sunday to Monday, and if you do another differential backup on Tuesday it will back all the things from Sunday to Tuesday so if you have to restore on Wednesday you will only need two backups the full backup from sunday and the differential backup from tuesday since that backup contains everything that happened from Sunday to tuesday .
upvoted 28 times
Tobee
3 years, 11 months ago
This is absolutely correct, the key thing about the question is the differential backup. 2 backups will be needed: the last full backup + the differential done on the Tuesday.
upvoted 7 times
...
...
Schwartzden
Highly Voted 4 years, 7 months ago
Only need to install one full back up and one differential backup from Tuesday morning at 2am. The full back up happened Saturday. No one typically works weekends so no differential backup needs to happen Sunday at 2am or Monday at 2am Since those cover the weekend
upvoted 12 times
...
Aarongreene
Most Recent 3 years ago
Thrown off by the Sunday backup. So: Saturday Full Backup (1) Sunday Diff Backup (2) Monday Diff Backup Restore on Tuesday. the answer is 2
upvoted 2 times
...
DW_2020
3 years, 6 months ago
***Remember - Differential is ALWAYS two backups to restore.*** Differential is a complete backup of the 'differences' from last full backup. Incremental is changes since the last incremental backup. So, differential restore = full backup plus one differential. Incremental restore = full backup + incremental 1 + incremental 2 etc. Usually a differential will be used as daily backup, with incremental backups used during that day so you have near real-time backup copies, and a full backup once a week, which then get archived in a Grandfather-father-son backup system
upvoted 5 times
Irv_NewJersey
3 years, 5 months ago
In most cases, yes you'll need 2 backups to restore when dealing w/ full + differentials. Depending on the day you lost data, you might just need one backup if you need to restore less than a day ago from the full backup. For this question, I agree, 2 backups are required.
upvoted 1 times
...
...
Ghana
3 years, 10 months ago
A database backup schedule consists of weekly full backups performed on Saturday at 12:00 a.m. and daily differential backups also performed at 12:00 a.m. If the database is restored on Tuesday afternoon, which of the following is the number of individual backups that would need to be applied to complete the database recovery? The weekly backup is done on Saturdays at 12 am. This means once in a week. Daily back up which I assume to be from Monday-Through Friday back up is done at 12am. Weekday beings on Monday @12am +1 and Tuesday @ 12am +1. Monday + Tuesday = 2 days. I hope this makes sense.
upvoted 2 times
...
ZZZZZZZZZZZZ
3 years, 10 months ago
Answer: 2
upvoted 1 times
...
virtualwalker
3 years, 11 months ago
At first i thought the answer was 3, but the catch is on the type of backup; see this from Wikipedia: A differential backup is a cumulative backup of all changes made since the last full backup, i.e., the differences since the last full backup. The advantage to this is the quicker recovery time, requiring only a full backup and the last differential backup to restore the entire data repository.
upvoted 2 times
...
covfefe
4 years ago
Think of it this way: differential results in more time spent on backups but less time on restoring while incremental results in less time spent on backups but more time spent on restoring.
upvoted 2 times
...
Tzu
4 years ago
Thrown off by the Sunday backup. So: Saturday Full Backup (1) Sunday Diff Backup (2) Monday Diff Backup Restore on Tuesday.
upvoted 2 times
...
MelvinJohn
4 years, 2 months ago
B. The differential backup accumulates all new and updated folders and files since the last full backup. So all you need is the last full backup and the most recent differential backup.
upvoted 2 times
...
Gerarigneel
4 years, 3 months ago
When you're doing differential backup and you need to restore data, you'd only need the Full backup and the LAST differential backup you did so the answer is 2
upvoted 3 times
...
Aun
4 years, 4 months ago
It's 2 because it's full backup on SAT and DIFF on everyday. Event we have to restore on Friday we still need only 2 individual backups. Read this: https://www.easeus.com/backup-utility/differential-backup-vs-incremental-backup.html
upvoted 9 times
...
Bahr
4 years, 5 months ago
Author of the question assumes No Work on Sunday, which I don't agree. That's not a universal rule. It should have been worded differently.
upvoted 3 times
...
Asmin
4 years, 7 months ago
yah it's 2 bclz diff. backup need to be stored individually since last full back. Rectify is i'm wrong.
upvoted 5 times
...
Stefanvangent
4 years, 8 months ago
I don't understand the answer. It's two back ups: the first full back up on Saturday and then the differential backup on Tuesday which backed up everything between Saturday and Tuesday?
upvoted 3 times
rafnex
4 years, 8 months ago
yeah it should be 3 since backup from Sat, Mon and Tuesday since the restore happens in the afternoon
upvoted 3 times
...
Jenkins3mol
4 years, 8 months ago
It’s differential back up, not incremental backup. The concepts are totally different. The answer is correct.
upvoted 21 times
...
Heymannicerouter
2 years, 11 months ago
In a differential backup you only need the last full backup and the last differential backup to restore everything
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...