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?

A.
Each successive differential database backup is larger than its predecessor, requiring more
backup time, space, and restore time.

B.
Each successive differential database backup is smaller than its predecessor, and requires
more backup tapes to secure.

C.
Full backups should be done every day to ensure all of the data is backed up.

D.
Full backups should be done more often to ensure that all of the data can be restored.

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.