Which strategy would best minimize data loss in a disaster recovery plan for a database?

Which strategy would best minimize data loss in a disaster recovery plan for a database?

• A. Data retention policy
• B. Full database backup
• C. Replication
• D. Data encryption

Answer: (C)

The strategy of replication is a robust approach to minimizing data loss in a disaster recovery plan for a database. Replication involves creating and maintaining copies of data in multiple locations or systems. This ensures that in the event of a disaster, such as hardware failure, data corruption, or a natural disaster that affects the primary database, there are up-to-date copies of the data available in secondary locations.

Replication can occur in real-time or at scheduled intervals, which means that changes made to the primary database are immediately or regularly updated to the secondary databases. This reduces the window of potential data loss to the time between the last replication event and the occurrence of the disaster.

While full database backup is a critical component of a disaster recovery plan, it typically involves taking periodic snapshots of the data. If a disaster strikes before the next scheduled backup, any data changes made since the last backup may be lost. Therefore, while backups are essential, they do not provide the same level of protection against data loss as replication.

A data retention policy provides guidelines for how long data should be stored and when it should be purged, but it does not actively protect against data loss during disaster scenarios. Data encryption, while important for security, does not inherently help with disaster recovery or minimizing