What is the primary purpose of data warehousing?
a) To store operational data
b) To provide a platform for data analysis and reporting
c) To store data temporarily
d) To process real-time data
Which of the following is a key characteristic of a data warehouse?
a) Data is updated in real-time
b) Data is non-volatile and only updated periodically
c) Data is stored in a transactional format
d) Data is stored in unstructured formats
Which process involves extracting, transforming, and loading data into a data warehouse?
a) Data mining
b) Data modeling
c) ETL (Extract, Transform, Load)
d) Data wrangling
What is the main purpose of data mining?
a) To store large amounts of data
b) To secure sensitive information
c) To discover patterns and knowledge from large datasets
d) To convert unstructured data into structured data
Which of the following is a type of data mining technique?
a) Regression analysis
b) Data warehousing
c) Data validation
d) Database management
What is OLAP (Online Analytical Processing) used for in data warehousing?
a) Storing data
b) Enabling complex data analysis through multi-dimensional views
c) Transforming data from unstructured to structured
d) Protecting data from unauthorized access
Which of the following is the main goal of data mining?
a) To organize data into a relational format
b) To reduce the amount of data for storage
c) To extract valuable insights and patterns from data
d) To ensure data security
Which of the following describes “data warehousing”?
a) The process of cleaning and transforming data for analysis
b) The process of storing and managing historical data for decision-making
c) A type of machine learning algorithm
d) A technique used to secure data
Which of the following is an example of a data mining technique?
a) Clustering
b) Indexing
c) Data encryption
d) Transaction logging
What is a “star schema” in data warehousing?
a) A method for visualizing data
b) A type of machine learning model
c) A data warehouse schema where a central fact table is connected to dimension tables
d) A method for cleaning unstructured data
Which of the following is NOT a feature of data warehousing?
a) Historical data storage
b) Real-time data updates
c) Data consolidation from multiple sources
d) Support for analytical processing
Which data mining technique is used to find associations between variables?
a) Classification
b) Regression
c) Association rule mining
d) Clustering
What is a “fact table” in a data warehouse?
a) A table that contains historical data
b) A table that contains measures or facts and foreign keys to dimension tables
c) A table that stores metadata
d) A table used to define the relationships between tables
What is a key feature of “data mining” tools?
a) They only analyze structured data
b) They help organizations identify trends and patterns in large datasets
c) They only store historical data
d) They provide real-time data analysis only
Which type of data is typically stored in a data warehouse?
a) Unstructured data
b) Operational data
c) Historical data from various sources
d) Transactional logs
What is “data preprocessing” in data mining?
a) Storing data for future analysis
b) Cleaning and transforming raw data into a usable format
c) Encrypting data for security
d) Visualizing data using graphs and charts
What is the purpose of a “dimension table” in a data warehouse?
a) To store the primary key for each record
b) To store measures like sales amounts
c) To store descriptive attributes for facts
d) To store raw data from transactional systems
Which of the following is a common data mining technique for classification?
a) K-means clustering
b) Decision tree analysis
c) Regression analysis
d) Association rule mining
What is the term “data warehouse architecture” referring to?
a) The physical design of the data warehouse
b) The design of the user interface for data analysis
c) The structure of data models used in data mining
d) The design of the ETL process
What is a “dimensional model” in data warehousing?
a) A model used to store real-time transactional data
b) A model that organizes data into facts and dimensions for analytical querying
c) A model used for machine learning algorithms
d) A model used to visualize data
Which of the following is a key objective of OLAP in data warehousing?
a) To process real-time transactional data
b) To perform multidimensional analysis of business data
c) To encrypt sensitive data
d) To perform data mining tasks
What does “data mining” help organizations to achieve?
a) Storing large amounts of data
b) Discovering hidden patterns and relationships in data
c) Converting raw data into structured data
d) Securing data from unauthorized access
What is the purpose of “data warehousing” in business intelligence?
a) To store data for a short period of time
b) To enable real-time analytics
c) To integrate data from various sources and enable complex analysis
d) To convert data into unstructured formats
What is “regression analysis” used for in data mining?
a) To classify data into categories
b) To predict numeric values based on existing data
c) To group similar data points together
d) To find relationships between variables
Which of the following is a common output of data mining techniques?
a) Raw data
b) Reports based on historical data
c) Predictive insights and patterns
d) Real-time transactional data
Which of the following is the role of “data mart” in data warehousing?
a) To store data for real-time processing
b) To store data for a specific department or business unit
c) To process large volumes of data
d) To convert unstructured data into structured data
What does “cluster analysis” help with in data mining?
a) Identifying unusual or rare data points
b) Grouping similar data points together
c) Finding correlations between variables
d) Predicting future outcomes
Which of the following is the main focus of “descriptive analytics”?
a) Predicting future trends
b) Summarizing historical data to identify patterns
c) Prescribing actions for business improvement
d) Identifying the root causes of problems
What is the purpose of “predictive analytics” in data mining?
a) To summarize past data
b) To classify data into different categories
c) To predict future outcomes based on historical data
d) To clean and transform data
Which of the following is a key component of data mining?
a) Encrypting data
b) Storing data in a central location
c) Analyzing large datasets to extract useful information
d) Managing data security
