How do online analytical processing systems improve performance?
A) They preaggregate data so that only the subset of the data necessary for the queries is extracted.
B) They use reasoning methods based on knowledge about a specific problem domain.
C) They make hypothetical changes to the data associated with a problem.
D) They allow for multiple dimensions to be added to a traditional two-dimensional table.
E) They provide capabilities for discovering "hidden" predictive relationships in the data.

Question

Quizplus · Accepted Answer

Online analytical processing systems improve performance by preaggregating data. This means that only the subset of the data necessary for the queries is extracted, which reduces the amount of data that needs to be processed and improves performance.

How Do Online Analytical Processing Systems Improve Performance