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

When recovering from multiple system failures, what is the biggest difficulty faced by a DBA?

Answer options

• A. Organising for the tapes to be delivered to the main data center
• B. Determining what version of the DBMS to recover - considering incremental patches
• C. Reseting active directory to reapply the security policies
• D. Determining what point to recover to using backups taken at different points in time
• E. Determining where the corrupt pages exist in the database file system

Correct answer: D

Explanation

The correct answer is D because when multiple backups are available, deciding the most appropriate point for recovery can be complex. Options A, B, C, and E, while challenging, do not present the same level of ambiguity and critical decision-making as selecting the right recovery point.