Data Warehousing and Mining Quiz

What is a data warehouse?

• A system used for transactional data processing

• A repository for storing structured data from multiple sources

• A tool for managing data processing in real-time

• A software used exclusively for managing network traffic

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

• Subject-oriented

• Integrated

• Non-volatile

• Real-time

The process of transforming data into a suitable format for analysis in a data warehouse is called:

• Data Mining

• ETL (Extract, Transform, Load)

• OLTP (Online Transaction Processing)

• Data Clustering

Which component in data warehousing is responsible for handling data integration?

• Data Mining

• Metadata Repository

• ETL Process

• OLAP Tools

Which of the following best describes OLAP?

• A method to organize databases for transactional processing

• A set of operations for multidimensional data analysis

• A way to secure data in a warehouse

• A tool for real-time data processing

Data granularity in a data warehouse refers to:

• The size of the data storage

• The level of detail in the data

• The speed of data processing

• The type of data sources

Which of the following is a primary task in data mining?

• Data extraction

• Pattern discovery

• Data warehousing

• Data redundancy

The 'K' in K-means clustering represents:

• The distance measure

• The number of clusters

• The number of data points

• The algorithm speed

Which technique is used to predict a categorical variable?

• Classification

• Regression

• Clustering

• Association Rule Mining

Which of the following methods is NOT used for dimensionality reduction?

• Principal Component Analysis (PCA)

• Singular Value Decomposition (SVD)

• Decision Trees

• Linear Discriminant Analysis (LDA)