UNIT-1 : Data Warehousing and OLAP

What is a data warehouse primarily used for?

• Operational database management

• Data entry and storage

• Decision support and analysis

• Real-time transaction processing

Which of the following is NOT a characteristic of a data warehouse?

• Subject-oriented

• Integrated

• Real-time

• Time-variant

What does ETL stand for in data warehousing?

• Evaluate, Transform, Load

• Extract, Transfer, Load

• Evaluate, Test, Load

• Extract, Transform, Load

Which of the following is a method of data preprocessing?

• Data cleaning

• Data mining

• Data warehousing

• Data visualization

What is the purpose of a metadata repository?

• To store operational data

• To define warehouse objects

• To perform data mining

• To manage user access

What type of data does a data mart typically contain?

• Data from all departments

• Data specific to a department

• Real-time operational data

• Historical data from multiple sources

What OLAP operation enables users to filter data to focus on specific dimensions?

• Slice

• Pivot

• Drill down

• Roll up

What is the main focus of OLTP systems?

• Data warehousing

• Data analysis

• Data mining

• Transaction processing

Which of the following is a common data warehouse model?

• Enterprise warehouse

• Operational database

• Transactional database

• Data entry system

What is the primary function of a fact table in a data warehouse?

• To define relationships

• To store measures and metrics

• To categorize data

• To store metadata