Data Warehouse and Data Mining_Module1

What is the main purpose of a data warehouse?

• To store temporary data

• To support decision making

• To perform real-time transaction processing

• To replace operational databases

In a multitier architecture of a data warehouse, the bottom tier is:

• OLAP server

• Data warehouse

• Data source

• Client

A _______ is a subset of a data warehouse that supports a specific group of users.

• Data Lake

• Data Mart

• Data Hub

• Data Grid

Which data warehouse model does not store data physically?

• Enterprise warehouse

• Data mart

• Virtual warehouse

• Operational warehouse

The process of extracting, cleaning, and loading data into a data warehouse is called:

• ETL

• OLAP

• OLTP

• ERP

Which component stores information about data in the data warehouse?

• Metadata Repository

• Data Mart

• Fact Table

• Data Cube

A data cube allows data to be modeled and viewed in:

• One dimension

• Two dimensions

• Multiple dimensions

• None of the above

A fact table contains:

• Only dimension attributes

• Only textual data

• Measurable, quantitative data

• Metadata

Which of the following is NOT a type of schema used in multidimensional models?

• Star schema

• Ring schema

• Snowflake schema

• Fact constellation schema

A fact constellation schema is also known as:

• Flat schema

• Galaxy schema

• Virtual schema

• Hybrid schema