4.6: Backup Schemes (Doshi)

Question 1

Type of backup:

Answer 1

Backup of full database and backup of only changed database

Question 2

Full backup:

Answer 2

Every time data backup is taken of full database irrespective of earlier backup

Question 3

What are included in backup of only changed (new database)?

Answer 3

differential backup and incremental backup

Question 4

Differential Backup:

Answer 4

Backup is taken only of data changed/modified since last full backup (last back to be full back-up only)

Question 5

Incremental Backup:

Answer 5

Backup is taken only of data changed/modified since last backup (last backup can be either full backup or incremental backup).

Question 6

Storage requirement for full backup:

Answer 6

Full Backup- Requires more time and storage capacity as compared to other two schemes.

Question 7

Storage requirement for Differential backup:

Answer 7

Differential- Requires less time and storage capacity as compared to full backup but more
time and storage capacity as compared to Incremental

Question 8

Storage requirement for Incremental backup:

Answer 8

Incremental- Requires less time and storage capacity as compared to other two schemes.

Question 9

Restoration speed for full backup:

Answer 9

Full Backup- Fastest of all three schemes

Question 10

Restoration speed for Differential backup:

Answer 10

Differential- Slower than Full backup but faster than incremental

Question 11

Restoration speed for Incremental backup:

Answer 11

Incremental-Slowest of all three schemes

Question 12

Backup scheme wherein every time data backup is taken of full database irrespective of earlier backup availability is known as:

A. Incremental Backup
B. Differential Backup
C. Grandfather-father-son rotation
D. Full Backup

Answer 12

D. Full Backup

CISA aspirants should understand various backup schemes as follow:
· Full Backup- Every time data backup is taken of full database irrespective of earlier backup.
· Incremental Backup-Backup is taken only of data changed/modified since last backup (last
backup can be either full backup or incremental backup).
· Differential Backup-Backup is taken only of data changed/modified since last full backup
(last back to be full back-up only).
· Grandfather-father-son rotation - This is a method of media rotation and not backup
scheme.

Question 13

Backup scheme wherein backup of data is taken only for data changed/modified either after full backup or incremental backup is known as:

A. Incremental Backup
B. Differential Backup
C. Grandfather-father-son rotation
D. Full Backup

Answer 13

A. Incremental Backup

CISA aspirants should understand various backup schemes as follow:
· Incremental Backup-Backup is taken only of data changed since last backup (last backup
can be either full backup or incremental backup).
· Differential Backup-Backup is taken only of data changed since last full backup (last back to
be full back-up only).
· Full Backup- Every time data backup is taken of full database irrespective of earlier backup.
· Grandfather-father-son rotation - This is a method of media rotation and not backup
scheme.

Question 14

Backup scheme wherein backup of data is taken only for data changed after full backup (incremental backup is ignored) is known as:

A. Incremental Backup
B. Differential Backup
C. Grandfather-father-son rotation Backup
D. Full Backup

Answer 14

B. Differential Backup

CISA aspirants should understand various backup schemes as follow:
· Differential Backup-Backup is taken only of data changed since last full backup (last back to
be full back-up only).
· Incremental Backup-Backup is taken only of data changed since last backup (last backup
can be either full backup or incremental backup).
Full Backup- Every time data backup is taken of full database irrespective of earlier backup.
· Grandfather-father-son rotation - This is a method of media rotation and not backup
scheme

Question 15

Which of the following backup scheme requires more time and media capacity for backup storage?

A. Incremental Backup
B. Differential Backup
C. Grandfather-father-son rotation Backup
D. Full Backup

Answer 15

D. Full Backup

In full backup, every time data backup is taken of full database irrespective of earlier backup. However, full backup scheme requires more time and media capacity for backup Storage.
Advantage of full backup scheme is easy restoration due to unique repository.
Let us understand requirement for time and media capacity for various schemes for data storage:
-Full Backup- Requires more time and storage capacity as compared to other two schemes.
-Differential- Requires less time and storage capacity as compared to full backup but more time and
storage capacity as compared to Incremental.
-Incremental- Requires less time and storage capacity as compared to other two schemes.

Question 16

Which of the following backup scheme is more effective and faster for data restoration?

A. Incremental Backup
B. Differential Backup
C. Grandfather-father-son rotation Backup
D. Full Backup

Answer 16

D. Full Backup

In full backup, every time data backup is taken of full database irrespective of earlier backup. Advantage of full backup scheme is easy restoration due to unique repository. However, full backup scheme requires more time and media capacity for backup Storage.
Let us understand effectiveness of various schemes in case of data restoration:
· Full Backup- Fastest of all three schemes.
· Differential- Slower than Full backup but faster than incremental.
· Incremental-Slowest of all three schemes.