Data Warehousing and Data Mining Quiz

What is the primary purpose of a data warehouse? (CO5)

• To store transactional data in real-time

• To support decision-making through historical data analysis

• To replace traditional databases

• To manage unstructured data

Which of the following is a characteristic of a data warehouse? (CO5)

• Volatile

• Subject-oriented

• Normalized

• Real-time updates

What is the process of extracting useful patterns from data called? (CO5)

• Data Warehousing

• Data Mining

• Data Cleaning

• Data Integration

Which of the following is NOT a data mining technique? (CO5)

• Classification

• Clustering

• Regression

• Normalization

What is the purpose of OLAP in data warehousing? (CO5)

• To perform real-time transactions

• To analyze multidimensional data

• To clean and transform data

• To store raw data

Which of the following is an example of a data mining application? (CO5)

• Predicting customer churn

• Storing sales data

• Managing employee records

• Generating invoices

What is the main goal of data preprocessing in data mining? (CO5)

• To reduce data size

• To improve data quality

• To visualize data

• To encrypt data

Which of the following is a data warehouse architecture? (CO5)

• Star Schema

• Neural Network

• Decision Tree

• Hash Table

What is the role of ETL in data warehousing? (CO5)

• To query data

• To extract, transform, and load data

• To visualize data

• To mine data

Which of the following is a data mining clustering algorithm? (CO5)

• Apriori

• K-Means

• Decision Tree

• Linear Regression