Question

____ is a method of querying and reporting that takes data from standard relational databases, calculates and summarizes the data, and then stores the data in a special database called a data cube. Ad hoc reporting E-discovery Data aggregation Online analytical processing Data adjacency

Answer 1

Answer: Online analytical processing

Step-by-step explanation:

Online analytical processing(OLAP) is the method through which multi-dimension analytical queries can be resolved.User can attain selected query data as per their selection and then assess and analyze them from different view point.

• It helps in viewing and reporting , planning ,performing analytical calculation, collecting data in data cubes etc.
• Other options are incorrect because data adjacency, Ad hoc reporting ,data segregation and E-discovery are not the mechanism through which query and storage of data in data cubes take place.
• Thus, the correct option is online analytical processing