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

Data replication is useful as it provides:

Answer options

• A. An alternative to backups
• B. Opportunities to secure sensitive data
• C. Enables different table structures to be built
• D. Insights into customer retention
• E. The ability to spread the workload across multiple databases

Correct answer: E

Explanation

The correct answer is E because data replication allows for load balancing by distributing tasks across multiple databases, enhancing performance and availability. Options A, B, C, and D do not accurately reflect the primary purpose of data replication, which focuses on workload distribution rather than backups, security, table structures, or customer insights.