Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday’s
backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day’s backup is
performed.
Which backup strategy satisfies the requirements?
A.
level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday,
and differential incremental level 1 backup on all the other days
B.
level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and
cumulative incremental level 1 backup on all the other days
C.
full database backup on Sunday, level 0 backup on Wednesday and Friday, and
cumulative incremental level 1 backup on all the other days
D.
full database backup on Sunday, level 0 backup on Wednesday and Friday, and
differential incremental level 1 backup on all the other days
A
I would also say A because on Wednesday or Friday with Cumulative seems easier to recover than with differential. Because differential only backups the changed blocks each day for that day. Cumulative will backup the blocks changed that day back to Sunday.
Its A
Multilevel Incremental Backups
RMAN can create multilevel incremental backups. Each incremental level is denoted by a value of 0 or 1. A level 0 incremental backup, which is the base for subsequent incremental backups, copies all blocks containing data. You can create a level 0 database backup as backup sets or image copies.
The only difference between a level 0 incremental backup and a full backup is that a full backup is never included in an incremental strategy. Thus, an incremental level 0 backup is a full backup that happens to be the parent of incremental backups whose level is greater than 0.
A level 1 incremental backup can be either of the following types:
A differential incremental backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0
A cumulative incremental backup, which backs up all blocks changed after the most recent incremental backup at level 0
Incremental backups are differential by default.
A
A
A
This Guy/lady who prepared this answer key must be an SQL Server DBA. they have such concpet wwhere cumulative is also called differential incremental
&
SQL server 2008 does not have any concept like incremental w/o cumulative.
I would go for A anyday.
A