FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Following are three steps in random order for creating a data cube. 1. Choose a data source 2. Create the query that extracts data from the database 3. Create the cube from the extracted data
A
1, 2, 3
B
2, 1, 3
C
3, 2, 1
D
3, 1, 2
Explanation: 

Detailed explanation-1: -In Solution Explorer, right-click Cubes, and then click New Cube. On the Select Creation Method page of the Cube Wizard, select Use existing tables, and then click Next. You might occasionally have to create a cube without using existing tables. To create an empty cube, select Create an empty cube.

Detailed explanation-2: -A data cube can also be described as the multidimensional extensions of two-dimensional tables. It can be viewed as a collection of identical 2-D tables stacked upon one another. Data cubes are used to represent data that is too complex to be described by a table of columns and rows.

Detailed explanation-3: -What is a Data Cube? A data cube (also called a business intelligence cube or OLAP cube) is a data structure optimized for fast and efficient analysis. It enables consolidating or aggregating relevant data into the cube and then drilling down, slicing and dicing, or pivoting data to view it from different angles.

There is 1 question to complete.
Previous
Next