MS SQL Data Mining Interview Question:

Tell me what are CUBES?

Submitted by: Administrator

A data cube stores data in a summarized version which helps in a faster analysis of data. The data is stored in such a way that it allows reporting easily.

E.g. using a data cube A user may want to analyze weekly, monthly performance of an employee. Here, month and week could be considered as the dimensions of the cube.
Submitted by: Administrator