Data Warehousing, Databases

Question: In a star schema, the central table which contains the individual facts being stored in the database is called a:
A
Fact table

B
Meta table

C
Data Dictionary

D
Pivot table

E
Dimension table

Note: Not available
1. Report
Question: Which of the following rules would be considered the central core of OLAP?
A
Multidimensional Conceptual View

B
Intuitive Data Manipulation

C
Accessibility

D
Batch Extraction vs Interpretative

E
Transparency

Note: Not available
1. Report
Question: Changing the view of the data to a greater level of detail is known as:
A
Explosion

B
Drill down

C
Drill up

D
Exploration

E
Aggregation

Note: Not available
1. Report
Question: A multidimensional cube records a set of data derived from:
A
Fact tables

B
Pivot tables

C
Dimensions

D
Fact tables and Dimensions

E
Fact tables and Pivot tables

Note: Not available
1. Report
Question: Which Data Mining technique partitions the database so that each partition or group is similar according to some criteria or metric ?
A
Clustering and Segmentation

B
Induction

C
Neural Networks

D
Data Visualisation

E
Linear Regression Analysis

Note: Not available
1. Report
Question: Which of the following is not associated with data warehousing?
A
Transaction processing

B
Information retrieval and analysis

C
Multi-dimensional data model

D
Query processing

E
Transformed and summarised data

Note: Not available
1. Report
Question: Which of the following is an architecture for OLAP?
A
MOLAP

B
ROLAP

C
KOLAP

D
MOLAP and ROLAP

E
MOLAP, ROLAP and KOLAP

Note: Not available
1. Report
Question: Under OLAP terminology, slice and dice refers to:
A
The user-initiated process of navigating by calling for page displays interactively, through the specification of slices via rotations and drill down/up

B
Restricting the view of database objects to a specified subset

C
A means of extending the data accessible to the end user beyond that which is stored in the OLAP server

D
Computing all of the data relationships for one or more dimensions

E
Applying calculations to input data at the time the request for that data is made

Note: Not available
1. Report
Question: In the Verification model of Data Mining, the emphasis is on which of the following?
A
The system automatically discovering important information hidden in the data

B
The user who is responsible for formulating the hypothesis and issuing the query on the data to affirm or negate the hypothesis

C
Volume of the data being examined

D
Timeliness of the data

E
Speed with which the data is examined

Note: Not available
1. Report
Question: The applications of Data Mining would not include:
A
Discovering buying-patterns for cross selling

B
Financial market prediction

C
Discovering errors made during data entry

D
Discovering which customer is most profitable

E
Credit assessment

Note: Not available
1. Report

First Prev 4 5 6 7 Next Last

Question: In a star schema, the central table which contains the individual facts being stored in the database is called a:

Question: Which of the following rules would be considered the central core of OLAP?

Question: Changing the view of the data to a greater level of detail is known as:

Question: A multidimensional cube records a set of data derived from:

Question: Which Data Mining technique partitions the database so that each partition or group is similar according to some criteria or metric ?

Question: Which of the following is not associated with data warehousing?

Question: Which of the following is an architecture for OLAP?

Question: Under OLAP terminology, slice and dice refers to:

Question: In the Verification model of Data Mining, the emphasis is on which of the following?

Question: The applications of Data Mining would not include: