Data Warehousing and Mining Quiz

Which of the following is NOT a type of Data Warehouse model?

• Enterprise Warehouse

• Data Mart

• Virtual Warehouse

• Distributed Transaction Store

In OLAP, which operation involves viewing data from different perspectives?

• Drill-down

• Roll-up

• Slice and Dice

• Pivot

Which schema uses fact tables linked to multiple dimension tables?

• Star Schema

• Snowflake Schema

• Fact Constellation

• Dimension Schema

The role of concept hierarchies in OLAP is to:

• Support data summarization

• Store raw data

• Improve transaction speed

• Index cube dimensions

Which of the following is NOT an OLAP operation?

• Roll-up

• Drill-down

• Join

• Pivot

Fact constellation schema is also called:

• Galaxy Schema

• Star Schema

• Snowflake Schema

• Fact Table

Metadata repository in Data Warehousing is used for:

• Storing operational data

• Storing data about data

• Transaction processing

• ETL only

ETL in Data Warehousing stands for:

• Extract, Transfer, Load

• Extract, Transform, Load

• Extract, Transaction, Load

• Extract, Translate, Load

Which OLAP model is represented by a multidimensional data cube?

• ROLAP

• MOLAP

• HOLAP

• OLTP

Which is NOT a component of a data warehouse?

• Metadata

• ETL tools

• Fact tables

• Trigger Functions