DWDM-2

 A data warehouse is which of the following?

• Can be updated by end users.

• Contains numerous naming conventions and formats.

• Organized around important subject areas.

• Contains only current data.

 ________ is a collection of data marts representing historical data from different operations in the company.

• data warehouse

• data mining 

• OLAP

• None of these

Data can be updated in _____environment.

• data mart

• data mining

• operational

• informational

 ______________ is data about data.

• Metadata

• Microdata

• Minidata

• Multidata

The star schema is composed of __________ fact table.

• 1

• 2

• 3

• Many

 ___________ is a good alternative to the star schema.

• Star schema.

• Snowflake schema.

• Fact constellation.

• Star-snowflake schema.

Fact tables are ___________.

• completely demoralized

• partially demoralized.

• completely normalized.

• partially normalized.

Which of the following is not true for data warehouse?

• Data warehouse contains subject oriented data

• Data warehouse contains only short duration recent data.

• Data warehouse provides analytical information for decision making process.

• Data warehouse is different from traditional database systems.

Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.

• Unusual

• Essential

• Optional

• None of the these

ROLAP refers to ............OLAP.

• Roll

• Rapid

• Running

• Relational