MOLAP

ROLAP

HOLAP

None of the above

True

False

Dispersed data -> Collected Data -> Integrated Data -> Information -> Knowledge

Collected Data -> Dispersed data -> Integrated Data -> Information -> Knowledge

Dispersed data -> Collected Data -> Integrated Data -> Knowledge-> Information

Collected Data -> Dispersed data -> Integrated Data -> Knowledge -> Informatio

Sourcing data from disparate sources and integrating to be central repository

A process to change data from a detailed level to a summary level

A process to change data from a summary level to a detailed level

Separating data from one source into various sources of data

Can be updated by end users.

Contains numerous naming conventions and formats.

Organized around important subject areas.

Contains only current data.

A system that is used to run the business in real time and is based on historical data.

A system that is used to run the business in real time and is based on current data.

A system that is used to support decision making and is based on current data.

A system that is used to support decision making and is based on historical data

True

False

Many-to-many

One-to-one

One-to-many

All of the above.

data enrichment

data caving

data refinement

data profiling

data eradication

data cleansing

data unloading

data purging

Metadata

Master data

Data Governance

Data Quality

Source layer

Report Layer

Data Warehouse

All of the above

Format is Employee Number – Number (6), Organization Name – Char (3)

Employee 123456 works for TCS for five years

Employee 123456 has worked in BIPM services

None of the above

Distributed

Federated

Centralized

Not possible to implement Metadata

Enterprise report

OLAP reports

GIS

Scorecards

True

False

Shared

Information

Collection

Multidimensional

Multidimensional data.

Pre-calculated data.

Nested data.

Slow data retrieval.

Dicing

Slicing

Rotating

Nesting

True

False