A DBA is reviewing the following logs to determine the current data backup plan for a primary data server: Which of the following best describes this backup plan?

The correct answer is D. Weekly full, daily incremental. The backup plan that best describes the logs is weekly full, daily incremental. This means that a full backup of the entire database is performed once a week, and then only the changes made since the last backup are backed up every day. This can be inferred from the logs by…

Database Management and Maintenance

Question

A DBA is reviewing the following logs to determine the current data backup plan for a primary data server:

Which of the following best describes this backup plan?

Exhibit

Options

AMonthly full, daily differential
BDaily differential
CDaily full
DWeekly full, daily incremental

How the community answered

(50 responses)

A
2% (1)
B
10% (5)
C
4% (2)
D
84% (42)

Explanation

The backup plan that best describes the logs is weekly full, daily incremental. This means that a full backup of the entire database is performed once a week, and then only the changes made since the last backup are backed up every day. This can be inferred from the logs by looking at the size and duration of the backups. The full backups are larger and take longer than the incremental backups, and they occur every seven days. The other backup plans do not match the pattern of the logs.

Topics

#Database Backup Types#Backup Plans#Database Administration#Data Protection

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice