A company's backup plan includes only running full backups for its small database. Which of the following frequencies would be most appropriate in this situation?

The correct answer is A. Daily. Daily backups are most appropriate for a full-backup-only strategy because full backups are comprehensive but time-consuming and storage-intensive - running them daily balances data protection (minimizing potential data loss to 24 hours) with operational feasibility for a small d

Database Management and Maintenance

Question

Options

ADaily
BMonthly
CWeekly
DQuarterly

How the community answered

(33 responses)

A
82% (27)
B
6% (2)
C
9% (3)
D
3% (1)

Explanation

Daily backups are most appropriate for a full-backup-only strategy because full backups are comprehensive but time-consuming and storage-intensive - running them daily balances data protection (minimizing potential data loss to 24 hours) with operational feasibility for a small database. Weekly backups (C) leave too large a recovery point objective gap, meaning up to 7 days of data could be lost in a failure scenario. Monthly (B) and quarterly (D) frequencies are far too infrequent for any active database, as businesses typically cannot afford weeks or months of data loss.

Memory tip: Think of the RPO (Recovery Point Objective) rule - the shorter your backup interval, the less data you lose. For a full-backup-only plan, daily is the sweet spot: frequent enough to protect data, feasible enough to run on a small database without overwhelming resources.

Topics

#Full Backup Frequency#Backup Strategy#Recovery Objectives#Database Backup

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice