Data Warehousing and Data Mining Quiz

Which of the following is NOT a primary goal of a data warehouse?

• Storing large volumes of operational data

• Supporting decision-making processes

• Providing historical data for analysis

• Integrating data from different sources

What is the main difference between a Data Warehouse and a Data Mart?

• A data mart is a smaller, more focused version of a data warehouse.

• A data warehouse stores unstructured data, while a data mart stores structured data.

• A data warehouse is used for real-time analytics, while a data mart stores historical data.

• There is no difference; they are used interchangeably.

In a star schema, what is the main structure that connects the fact table to dimension tables?

• Primary key

• Foreign key

• Attribute key

• Composite key

Which of the following is the first step in the ETL process for data warehousing?

• Transformation

• Loading

• Extraction

• Aggregation

Which of the following is a characteristic of OLAP (Online Analytical Processing)?

• Optimized for transactional queries

• Stores data in tables with rows and columns

• Supports multidimensional data analysis

• Limited to real-time processing of data

Which of the following data mining techniques is used to group similar data points into clusters?

• Classification

• Regression

• Clustering

• Association rule mining

What does the 'support' measure in association rule mining indicate?

• The strength of the correlation between items

• The probability that an item occurs in a transaction

• The frequency of a rule being applicable in the dataset

• The confidence level of the rule

In data mining, which algorithm is commonly used for classification?

• K-Means

• Apriori

• Decision Trees

• DBSCAN

Which of the following is NOT an example of supervised learning in data mining?

• Decision Trees

• Linear Regression

• K-Means Clustering

• Naive Bayes

What is the purpose of the "lift" metric in association rule mining?

• To evaluate the strength of the association between items

• To measure the frequency of transactions

• To determine the accuracy of the model

• To assess how well the rule predicts the outcome