Lecture 2
1. What is the primary function of Transaction Processing Systems (TPS)?
- A) Managing updates to operational databases
- B) Conducting ad hoc analysis
- C) Storing data for long-term analysis
- D) Generating real-time reports
**Answer: A) Managing updates to operational databases**
2. Which system handles routine ongoing business transactions?
- A) OLAP
- B) DW
- C) OLTP
- D) CRM
**Answer: C) OLTP**
3. What type of system provides storage for data used for analysis?
- A) OLTP
- B) DW
- C) POS
- D) SCM
**Answer: B) DW**
4. What is the primary purpose of OLAP systems?
- A) Managing updates to operational databases
- B) Capturing and storing day-to-day business functions
- C) Providing ad hoc analysis of organizational data
- D) Automating routine analysis
**Answer: C) Providing ad hoc analysis of organizational data**
5. How do OLAP and OLTP systems relate to each other?
- A) OLAP automates business processes managed by OLTP
- B) OLTP uses data captured by OLAP
- C) OLAP and OLTP are entirely independent systems
- D) OLTP provides ad hoc analysis for OLAP
**Answer: B) OLTP uses data captured by OLAP**
6. What is the primary role of Online Transaction Processing (OLTP) systems?
- A) Conducting ad hoc analysis
- B) Handling routine ongoing business transactions
- C) Storing data for long-term analysis
- D) Generating real-time reports
**Answer: B) Handling routine ongoing business transactions**
7. How does a Data Warehouse (DW) differ from a Transaction Processing System (TPS)?
- A) TPS focuses on ad hoc analysis, while DW focuses on routine transactions.
- B) TPS handles updates to operational databases, while DW provides storage for data
used for analysis.
- C) TPS is primarily used for long-term analysis, while DW is used for real-time reports.
- D) TPS automates routine analysis, while DW generates real-time reports.
**Answer: B) TPS handles updates to operational databases, while DW provides storage
for data used for analysis.**
8. What distinguishes Online Analytical Processing (OLAP) systems from Online
Transaction Processing (OLTP) systems?
- A) OLTP systems provide ad hoc analysis, while OLAP systems handle routine
transactions.
- B) OLAP systems automate daily business transactions, while OLTP systems provide ad
hoc analysis.
- C) OLTP systems capture and store data related to day-to-day business functions, while
OLAP systems provide ad hoc analysis of organizational data.
- D) OLAP systems generate real-time reports, while OLTP systems manage updates to
operational databases.
**Answer: C) OLTP systems capture and store data related to day-to-day business
functions, while OLAP systems provide ad hoc analysis of organizational data.**
9. What is the primary purpose of a data warehouse?
- A) Storing operational data
- B) Providing support for decision making
- C) Conducting real-time transactions
- D) Managing historical records
**Answer: B) Providing support for decision making**
10. What distinguishes a data warehouse from an operational database?
- A) Operational databases are subject-oriented, while data warehouses are product-
oriented.
- B) Data warehouses are time-variant, while operational databases are nonvolatile.
- C) Data warehouses maintain historical data, while operational databases handle real-
time transactions.
- D) Operational databases are integrated, while data warehouses are structured for
analytical processing.
**Answer: C) Data warehouses maintain historical data, while operational databases
handle real-time transactions.**
11. What does it mean for a data warehouse to be “subject-oriented”?
- A) Data are organized by detailed subject, containing only information relevant for
decision support.
- B) Data are structured to be available for analytical processing activities.
- C) Data from different sources are placed into a consistent format.
- D) Data are integrated to ensure consistency and accuracy.
**Answer: A) Data are organized by detailed subject, containing only information relevant
for decision support.**
12. Why is integration important in a data warehouse?
- A) It ensures that data are structured for analytical processing activities.
- B) It allows users to determine how their business is performing.
- C) It places data from different sources into a consistent format.
- D) It maintains historical records of data.
**Answer: C) It places data from different sources into a consistent format.**
13. What characteristic ensures that data warehouses maintain historical data?
- A) Subject orientation
- B) Integration
- C) Time variant
- D) Nonvolatile
**Answer: C) Time variant**
14. What is the role of metadata in a data warehouse?
- A) Managing historical records
- B) Providing support for decision making
- C) Organizing data into consistent formats
- D) Describing how the data are organized and how to effectively use them
**Answer: D) Describing how the data are organized and how to effectively use them**
15. What is the difference between a data warehouse and data warehousing?
- A) A data warehouse is subject-oriented, while data warehousing is time-variant.
- B) A data warehouse is a repository of data, while data warehousing is the entire
process.
- C) A data warehouse is nonvolatile, while data warehousing is integrated.
- D) A data warehouse provides real-time access, while data warehousing provides
historical records.
**Answer: B) A data warehouse is a repository of data, while data warehousing is the
entire process.**
16. What is the primary purpose of a data warehouse according to the text?
- A) Providing support for decision making
- B) Storing operational data
- C) Conducting real-time transactions
- D) Managing historical records
**Answer: A) Providing support for decision making**
17. How does a data warehouse differ from an operational database?
- A) Operational databases are subject-oriented, while data warehouses are product-
oriented.
- B) Data warehouses are time-variant, while operational databases are nonvolatile.
- C) Data warehouses maintain historical data, while operational databases handle real-
time transactions.
- D) Operational databases are integrated, while data warehouses are structured for
analytical processing.
**Answer: C) Data warehouses maintain historical data, while operational databases
handle real-time transactions.**
18. What are the characteristics of a subject-oriented data warehouse?
- A) Data are structured for analytical processing activities.
- B) Data are organized by detailed subject, containing only information relevant for
decision support.
- C) Data from different sources are placed into a consistent format.
- D) Data are integrated to ensure consistency and accuracy.
**Answer: B) Data are organized by detailed subject, containing only information relevant
for decision support.**
19. Why is integration important in a data warehouse?
- A) It ensures that data are structured for analytical processing activities.
- B) It allows users to determine how their business is performing.
- C) It places data from different sources into a consistent format.
- D) It maintains historical records of data.
**Answer: C) It places data from different sources into a consistent format.**
20. What characteristic ensures that data warehouses maintain historical data?
- A) Subject orientation
- B) Integration
- C) Time variant
- D) Nonvolatile
**Answer: C) Time variant**
21. What role does metadata play in a data warehouse?
- A) Managing historical records
- B) Providing support for decision making
- C) Organizing data into consistent formats
- D) Describing how the data are organized and how to effectively use them
**Answer: D) Describing how the data are organized and how to effectively use them**
22. What is the difference between a data warehouse and data warehousing according to
the text?
- A) A data warehouse is subject-oriented, while data warehousing is time-variant.
- B) A data warehouse is a repository of data, while data warehousing is the entire
process.
- C) A data warehouse is nonvolatile, while data warehousing is integrated.
- D) A data warehouse provides real-time access, while data warehousing provides
historical records.
**Answer: B) A data warehouse is a repository of data, while data warehousing is the
entire process.**
23. What are the main activities supported by a data warehouse, as mentioned in the text?
- A) Online shopping and transactions
- B) Decision support capability and business insight
- C) Real-time data processing
- D) Inventory management and sales tracking
**Answer: B) Decision support capability and business insight**
24. How does the text describe the subject-oriented aspect of a data warehouse?
- A) It organizes data by detailed subject, such as sales or products, containing only
relevant information for decision support.
- B) It integrates data from different sources into a consistent format.
- C) It maintains historical data to detect trends and deviations.
- D) It provides metadata about the data organization and usage.
**Answer: A) It organizes data by detailed subject, such as sales or products, containing
only relevant information for decision support.**
25. Why is integration important in a data warehouse, according to the text?
- A) To ensure real-time data access
- B) To maintain historical records
- C) To place data from different sources into a consistent format
- D) To support ad hoc analysis
**Answer: C) To place data from different sources into a consistent format**
26. What does it mean for a data warehouse to be time-variant?
- A) It provides real-time access to data
- B) It maintains historical data for trend analysis and comparisons
- C) It integrates data from multiple sources
- D) It organizes data by detailed subject
**Answer: B) It maintains historical data for trend analysis and comparisons**
27. How does the nonvolatile characteristic of a data warehouse affect data management?
- A) It allows users to update data as needed
- B) It ensures that obsolete data are discarded
- C) It enables real-time data processing
- D) It limits data access to specific users
**Answer: B) It ensures that obsolete data are discarded**
28. What additional characteristics of data warehouses are mentioned in the text?
- A) Mobile compatibility and cloud storage
- B) Web-based, relational/multidimensional, client/server architecture, real-time
access, and metadata
- C) Offline processing and manual data entry
- D) Batch processing and hierarchical structure
**Answer: B) Web-based, relational/multidimensional, client/server architecture, real-
time access, and metadata**
29. What is the relationship between data warehouse and data warehousing, according to
the text?
- A) They refer to the same concept
- B) Data warehousing is a process that results in a data warehouse
- C) Data warehousing is another term for data integration
- D) Data warehouses are only used for historical data, while data warehousing handles
real-time data
**Answer: B) Data warehousing is a process that results in a data warehouse**
30. How does a data warehouse support decision-making processes?
- A) By conducting ad hoc analysis
- B) By storing operational data
- C) By providing historical and current data for analysis
- D) By processing real-time transactions
**Answer: C) By providing historical and current data for analysis**
31. What is the purpose of metadata, as described in the text?
- A) Storing operational data
- B) Describing the structure and meaning of data
- C) Conducting data analysis
- D) Creating data warehouses
**Answer: B) Describing the structure and meaning of data**
32. According to Mehra (2005), what is the common challenge organizations face regarding
metadata?
- A) Understanding how to design and implement a metadata strategy
- B) Defining metadata in terms of usage
- C) Creating patterns for metadata organization
- D) Implementing technical and business metadata
**Answer: A) Understanding how to design and implement a metadata strategy**
33. How does the pattern view differentiate metadata?
- A) By categorizing metadata as technical or business
- B) By differentiating between syntactic, structural, and semantic metadata
- C) By organizing metadata based on their usage
- D) By creating patterns for metadata implementation
**Answer: B) By differentiating between syntactic, structural, and semantic metadata**
34. What is the primary purpose of data warehouses, as mentioned in the text?
- A) Storing time series data for decision support
- B) Conducting real-time transactions
- C) Managing operational databases
- D) Organizing metadata for data analysis
**Answer: A) Storing time series data for decision support**
35. How are data organized in a data warehouse after being imported from various
sources?
- A) They are loaded directly into decision models (DMs)
- B) They are cleansed and organized according to the organization’s needs
- C) They are stored in a staging area for future processing
- D) They are integrated into legacy systems
**Answer: B) They are cleansed and organized according to the organization’s needs**
36. What are the main components of data warehouses, as described in the text?
- A) Data lakes and cloud storage
- B) Data extraction and transformation tools
- C) Relational databases and OLTP systems
- D) Metadata management and middleware tools
**Answer: B) Data extraction and transformation tools**
37. What role do middleware tools play in accessing data warehouses?
- A) They enable access to the data warehouse for power users only
- B) They provide access to data repositories for business users
- C) They are used exclusively for data mining and OLAP
- D) They facilitate data loading into the staging area
**Answer: B) They provide access to data repositories for business users**
38. How are metadata maintained in data warehouses?
- A) They are organized using custom-written software
- B) They are stored in a separate database
- C) They are managed for assessment by IT personnel and users
- D) They are integrated into decision models (DMs)
**Answer: C) They are managed for assessment by IT personnel and users**
39. What are some examples of front-end applications used to interact with data stored in
data warehouses?
- A) Email clients and word processors
- B) Data mining and OLAP tools
- C) Graphics design software
- D) Project management tools
**Answer: B) Data mining and OLAP tools**
40. How does the text describe the role of comprehensive databases in data warehouses?
- A) They summarize data for easy indexing and searching
- B) They store raw data without any transformation
- C) They provide access to external data providers
- D) They support decision analysis by providing relevant information from different
sources
**Answer: D) They support decision analysis by providing relevant information from
different sources**