6: Backup Schemes

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

(1)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

Answer: D. Full Backup

Explanation:
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

(2)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

Answer: A. Incremental Backup

Explanation:
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

(3)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

Answer: B. Differential Backup

Explanation:
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

(4)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

Answer: D. Full Backup

Explanation: 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

(5)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

Answer: D. Full Backup

Explanation: 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.