MS SQL Data Mining Question:

Download Job Interview Questions and Answers PDF

Tell me what are CUBES?

SQL Server Data Mining Interview Question
SQL Server Data Mining Interview Question

Answer:

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.

Download SQL Server Data Mining Interview Questions And Answers PDF

Previous QuestionNext Question
Explain what are the different problems that “Data mining” can solve?What is Rollup and cube?