Data warehouse Unit 1 Activity

Identify the correct option which defines Datamart.

• A Subgroup of the Data warehouse

• Another type of Data Warehouse

• Not Related to Data Warehouse

• None

State whether True or False: Data warehouse is generally updated in real-time.

• True

• False

Identify the options below that a data warehouse can include

• Database table

• Online data

• Flat files

• All the Above

Identify among the following for which system of data warehousing is mostly used.

• Data mining and Data Storage

• Data Integration and Data Storage

• Reporting and Data Analysis

• Data cleaning and Data Storage

Where is data warehousing used?

• Transaction System

• Logical System

• Decision Support System

• No

Small logical units where data warehouses hold large amounts of data is known as _____

• Access layers

• Data Mart

• Data Storage

• Data Miners

Choose the incorrect property of the data warehouse.

• Collection of Heterogeneous Sources

• Subject Oriented

• Time Variant

• Volatile

Identify the operation which can be performed in the data warehouse.

• Alter

• Modify

• Scan

• Read/Write

On what is data warehouse based?

• 1 D Model

• 2 D Model

• 3 D Model

• Multidimensional Model

Identify the term used to define the multidimensional model of the data warehouse

• Table

• Tree

• Data Cube

• Data Structure