Which of the following outlines why replication is important during database management?

Question

Options

• ATo ensure that all vulnerabilities within the database are classified and mitigated
• BTo ensure consistency, availability, and reliability between databases
• CTo ensure the performance of web applications is improved
• DTo ensure that an administrator can easily retrieve data from the database

• B
  93% (27)
• C
  3% (1)
• D
  3% (1)

Explanation

Replication copies data across multiple database servers to maintain synchronized copies, which directly achieves consistency (all copies hold the same data), availability (if one server fails, others serve requests), and reliability (data is not lost due to a single point of failure) - making B the correct answer.

Why the distractors are wrong:

• A describes vulnerability management/security patching, which is a separate discipline from replication.
• C is a side effect that may result from replication (e.g., read replicas reducing load), but it is not the purpose of replication itself.
• D describes indexing or query optimization, not replication - replication is about redundancy, not retrieval convenience.

Memory tip: Think of replication as making backup twins of your database - the twins keep each other honest (consistency), cover for each other when one is sick (availability), and prevent total data loss (reliability). The acronym CAR (Consistency, Availability, Reliability) maps directly to option B.

No community discussion yet for this question.