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 to outline how sensitive information will be handled, stored, transmitted, and destroyed.
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 so that only the subset of the data necessary for the queries is extracted. This reduces the query response time and improves system performance.

How Do Online Analytical Processing Systems Improve Performance