Database Disaster Recovery Testing Quiz

1. A warm standby site differs from a cold standby site in that it:

Has systems running with synchronized data

Requires no equipment or infrastructure

Takes weeks to activate

Only stores backup tapes

2. True or False: Asynchronous replication guarantees zero data loss in all disaster scenarios.

True

False

3. Which factor has the greatest impact on determining appropriate RTO values?

Business criticality of the application

Size of the database

Database software version

Number of backup copies

4. Match each testing type with its characteristic:

Tabletop Exercise

Full-Scale Test

Parallel Test

Submit

5. A pilot test in disaster recovery involves:

Testing recovery with a subset of data and users

Discussing recovery plans without implementation

Testing only network connectivity

Simulating disasters on production systems

6. Which backup strategy provides the shortest recovery time for large databases?

Full backup only

Incremental backups

Continuous data protection

Monthly archival backup

Submit

8. What does MTTR stand for in disaster recovery contexts?

Mean Time To Recovery

Maximum Transfer Time Requirement

Minimum Test Threshold Rate

Multi-Tier Technology Rollback

9. True or False: Disaster recovery testing should only occur during scheduled maintenance windows.

True

False

10. Which technique involves creating an exact copy of a database for testing without affecting production?

Database cloning

Log shipping

Transaction mirroring

Index optimization

11. What does RTO stand for in the context of disaster recovery?

Recovery Time Objective

Rapid Transfer Operation

Redundant Topology Optimization

Recovery Threshold Overload

Submit

13. What is the main advantage of using database snapshots in disaster recovery?

Instant recovery to a known consistent state

Eliminates need for backups

Reduces storage costs

Improves query performance

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

Backup and recovery procedures

Communication protocols

Alternative processing sites

Marketing strategy

Submit

16. Which testing approach simulates a disaster without affecting production systems?

Parallel testing

Destructive testing

Blue-green deployment

Chaos engineering on live systems

17. In database replication, synchronous replication ensures:

Data is written to primary only

Data written to primary and replicas before commit

Faster writes with potential data loss

No network communication required

18. What is the primary purpose of a full-scale disaster recovery test?

Identify and resolve weaknesses in recovery plans

Reduce database licensing costs

Eliminate the need for backups

Increase network bandwidth

19. A tabletop exercise in disaster recovery testing involves:

Actual failover to backup systems

Discussion-based walkthrough of recovery procedures

Full production database migration

Automated backup verification

20. Which metric defines the maximum acceptable amount of data loss during a disaster?

RTO

RPO

MTTR

SLA

DataSys+ Disaster Recovery Testing for Databases Quiz

1. A warm standby site differs from a cold standby site in that it:

2.

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

2. True or False: Asynchronous replication guarantees zero data loss in all disaster scenarios.

3. Which factor has the greatest impact on determining appropriate RTO values?

4. Match each testing type with its characteristic:

5. A pilot test in disaster recovery involves:

6. Which backup strategy provides the shortest recovery time for large databases?

7. Automated ____ validation is critical to ensure recovery procedures execute correctly.

8. What does MTTR stand for in disaster recovery contexts?

9. True or False: Disaster recovery testing should only occur during scheduled maintenance windows.

10. Which technique involves creating an exact copy of a database for testing without affecting production?

11. What does RTO stand for in the context of disaster recovery?

12. Failover testing should occur ____ to ensure recovery procedures remain effective.

13. What is the main advantage of using database snapshots in disaster recovery?

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

15. A Recovery Point Objective of 1 hour means data loss up to ____.

16. Which testing approach simulates a disaster without affecting production systems?

17. In database replication, synchronous replication ensures:

18. What is the primary purpose of a full-scale disaster recovery test?

19. A tabletop exercise in disaster recovery testing involves:

20. Which metric defines the maximum acceptable amount of data loss during a disaster?