70-177 · Question #92
Joan is the Microsoft Project Server administrator for her organization and she has hired you to consult with her about the backup and restore process for her SQL servers. She is worried that her…
The correct answer is A. Each successive differential database backup is larger than its predecessor, requiring more backup. Differential backups record everything that has changed since the last full backup. The more things change the larger the differential backups will be. In additional, the more tapes that are created the longer the restore process will be in case of a fault.
Question
Joan is the Microsoft Project Server administrator for her organization and she has hired you to consult with her about the backup and restore process for her SQL servers. She is worried that her current backup strategy is not accurate for the busy servers she has in her organization. She is currently completing a full backup every three weeks and differential backups daily. What is the immediate danger in Joan's backup schedule?
Options
- AEach successive differential database backup is larger than its predecessor, requiring more backup
- BEach successive differential database backup is smaller than its predecessor, and requires more
- CFull backups should be done every day to ensure all of the data is backed up.
- DFull backups should be done more often to ensure that all of the data can be restored.
How the community answered
(14 responses)- A79% (11)
- C7% (1)
- D14% (2)
Explanation
Differential backups record everything that has changed since the last full backup. The more things change the larger the differential backups will be. In additional, the more tapes that are created the longer the restore process will be in case of a fault.
Topics
Community Discussion
No community discussion yet for this question.