4.6: Backup Schemes (Doshi) Flashcards

1
Q

Type of backup:

A

Backup of full database and backup of only changed database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Full backup:

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

differential backup and incremental backup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Differential Backup:

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Incremental Backup:

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Storage requirement for full backup:

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Storage requirement for Differential backup:

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Storage requirement for Incremental backup:

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Restoration speed for full backup:

A

Full Backup- Fastest of all three schemes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Restoration speed for Differential backup:

A

Differential- Slower than Full backup but faster than incremental

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Restoration speed for Incremental backup:

A

Incremental-Slowest of all three schemes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

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.