WAEC Data Processing 2017 Question 40

Question 40

Distributed and Parallel Databases

Which of these operations would not improve the performance of a parallel database system?

  1. A.Building indexes
  2. B.Deleting unwanted data
  3. C.Evaluating queries
  4. D.Storing data across several sites
Show the answer and explanation

Answer: D (Storing data across several sites)

Explanation

Indexes, smaller tables and query optimisation speed up a parallel database; spreading data across distant sites adds network delay.