DMDW-1

1. Identify the correct option which defines Datamart.

• A subgroup of data warehouse

• Another type of data warehouse

• Not relate to data warehouse

• None

2. Identify the options below that a data warehouse can include.

• Database table

• Online data

• Flat files

• All of the above

3. 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

4. Where the data warehousing used?

• Transaction System

• Logical System

• Decision Support System

• None

5. Which one is the incorrect property of the data warehouse.

• Collection from Heterogeneous Sources

• Subject Oriented

• Time Variant

• Volatile

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

• Alter

• Scan

• Modify

• Read/Write

7. What model the data warehouse based?

• 1D model

• 2D model

• 3D model

• Multidimensional

8. Where can the data be updated?

• Information environment

• Operational environment

• Data warehouse environment

• Data mining environment

9. Which one is responsible for running queries and reports against data warehouse tables?

• End-users

• Programmer

• Software

• Middleware

10. How many approaches are there in data warehousing to integrate heterogeneous databases?

• 5

• 2

• 3

• 4