Database Backup Types and Strategy Quiz

Submit

3. Which backup strategy offers the best balance between storage efficiency and recovery speed?

Incremental backups only

Full backups only

Combination of full and incremental backups

Snapshot backups only

4. True or False: A disaster recovery plan is complete once created and does not require updates.

True

False

Submit

6. What factor most significantly influences the choice between incremental and differential backups?

Database size alone

Restore speed requirements and change rate

Backup software vendor

Day of the week backups are scheduled

7. Which of the following best describes a warm standby site?

Fully operational mirror of production environment

Partially synchronized, requires manual failover activation

Offline with backups ready for manual restoration

Replicated monthly without continuous synchronization

Submit

9. True or False: Geographically dispersed backups reduce risk from regional disasters.

True

False

10. Which backup type requires the longest time to restore but uses the least storage?

Incremental backup

Differential backup

Full backup

Snapshot backup

11. Which backup type copies all data from the source regardless of previous backups?

Full backup

Incremental backup

Differential backup

Snapshot backup

12. What is the primary purpose of a 3-2-1 backup rule?

Backup three times daily to three locations

Three copies of data, two on different media, one offsite

Three databases, two replicas, one archive

Three backup types, two verification methods, one restore test

13. True or False: Cold standby sites are less expensive than hot standby sites.

True

False

14. Which of the following are key components of a disaster recovery plan? (Select all that apply)

Recovery procedures and runbooks

Backup storage location and verification

Communication protocols

Employee vacation schedules

Submit

16. Which backup strategy minimizes backup window time while maintaining fast recovery?

Daily full backups only

Weekly full backup plus daily incremental backups

Monthly full backup only

Continuous data replication without backups

17. True or False: RPO defines the maximum amount of data that can be lost during a failure.

True

False

Submit

19. What is the primary advantage of differential backups over incremental backups?

They require less storage space

Faster restore because only two backup sets are needed

They eliminate the need for full backups

They automatically compress data

Submit

DataSys+ Database Backup Types and Strategy Quiz

1. Database backups should be tested regularly through ______ to ensure recoverability.

2.

What first name or nickname would you like us to use?

2. Off-site backup storage should be located at least ______ miles from the primary data center.

3. Which backup strategy offers the best balance between storage efficiency and recovery speed?

4. True or False: A disaster recovery plan is complete once created and does not require updates.

5. Backup encryption protects data from ______ during storage and transmission.

6. What factor most significantly influences the choice between incremental and differential backups?

7. Which of the following best describes a warm standby site?

8. A hot standby system maintains ______ synchronization with the primary database.

9. True or False: Geographically dispersed backups reduce risk from regional disasters.

10. Which backup type requires the longest time to restore but uses the least storage?

11. Which backup type copies all data from the source regardless of previous backups?

12. What is the primary purpose of a 3-2-1 backup rule?

13. True or False: Cold standby sites are less expensive than hot standby sites.

14. Which of the following are key components of a disaster recovery plan? (Select all that apply)

15. A snapshot backup is typically used for ______ recovery rather than long-term storage.

16. Which backup strategy minimizes backup window time while maintaining fast recovery?

17. True or False: RPO defines the maximum amount of data that can be lost during a failure.

18. RTO stands for Recovery ______ Objective.

19. What is the primary advantage of differential backups over incremental backups?

20. An incremental backup captures only data changed since the ______ backup.