Certified Data Management Professional – Fundamentals (CDMP) — Question 17

The best way to validate that a database backup is working, is to:

Answer options

• A. Periodically recover from the backup file
• B. Check the backup logs every day
• C. Appoint a special DBA in charge of backups
• D. Check the size of the backup file
• E. Check for the automatic email notification of backup success

Correct answer: A

Explanation

The correct answer is A, as periodically recovering from the backup file is the only definitive way to verify that the backup can be restored successfully. The other options, such as checking logs or file sizes, do not guarantee that the backup is usable, and appointing a DBA does not address the validation process directly.