ISM 4402 MIDTERM EXAM CH.3 QUESTIONS
False - Answer -Moving the data into a data warehouse is usually the easiest part of its
creation.
What is Six Sigma? - Answer -a methodology aimed at reducing the number of defects
in a business process
True - Answer -With key performance indicators, driver KPIs have a significant effect
on outcome KPIs, but the reverse is not necessarily true.
extraction, transformation, and load (ETL) - Answer -Performing extensive ________ to
move data to the data warehouse may be a sign of poorly managed data and a
fundamental lack of a coherent data management strategy.
False - Answer -OLTP systems are designed to handle ad hoc analysis and complex
queries that deal with many data items.
improved customer service - Answer -Data warehouses provide direct and indirect
benefits to organizations. Which of the following is an indirect benefit of data
warehouses?
Enterprise application integration - Answer -________ is a mechanism that integrates
application functionality and shares functionality (rather than data) across systems,
thereby enabling flexibility and reuse.
All of the following are true about in-database processing technology EXCEPT -
Answer -it pushes the algorithms to where the data is.
it makes the response to queries much faster than conventional databases.
it is often used for apps like credit card fraud detection and investment risk
management.
***it is the same as in-memory storage technology***
three-tier architecture. - Answer -A Web client that connects to a Web server, which is
in turn connected to a BI application server, is reflective of a
False - Answer -User-initiated navigation of data through disaggregation is referred to
as "drill up."
hub-and-spoke data warehouse architecture - Answer -Which data warehouse
architecture uses a normalized relational warehouse that feeds multiple data marts?
True - Answer -The hub-and-spoke data warehouse model uses a centralized
warehouse feeding dependent data marts.
, Inmon - Answer -The ________ Model, also known as the EDW approach, emphasizes
top-down development, employing established database development methodologies
and tools, such as entity-relationship diagrams (ERD), and an adjustment of the spiral
development approach.
Transaction processing - Answer -Online ________ is a term used for a transaction
system that is primarily responsible for capturing and storing data related to day-to-day
business functions such as ERP, CRM, SCM, and point of sale.
parallel processing - Answer -Which of the following BEST enables a data warehouse
to handle complex queries and scale up to handle many more requests?
star schema - Answer -When representing data in a data warehouse, using several
dimension tables that are each connected only to a fact table means you are using
which warehouse structure?
Mention briefly some of the recently popularized concepts and technologies that will
play a significant role in defining the future of data warehousing. - Answer -Sourcing
(mechanisms for acquisition of data from diverse and dispersed sources):
o Web, social media, and Big Data
o Open source software
o SaaS (software as a service)
o Cloud computing
• Infrastructure (architectural—hardware and software—enhancements):
o Columnar (a new way to store and access data in the database)
o Real-time data warehousing
o Data warehouse appliances (all-in-one solutions to DW)
o Data management technologies and practices
o In-database processing technology (putting the algorithms where the data is)
o In-memory storage technology (moving the data in the memory for faster processing)
o New database management systems
o Advanced analytics
federated - Answer -The ________ data warehouse architecture involves integrating
disparate systems and analytical resources from multiple sources to meet changing
needs or business conditions.
What are the four processes that define a closed-loop BPM cycle? - Answer -The four
processes that define a closed-loop BPM cycle are:
1. Strategize: Where do we want to go?
2. Plan: How do we get there?
3. Monitor/Analyze: How are we doing?
False - Answer -Moving the data into a data warehouse is usually the easiest part of its
creation.
What is Six Sigma? - Answer -a methodology aimed at reducing the number of defects
in a business process
True - Answer -With key performance indicators, driver KPIs have a significant effect
on outcome KPIs, but the reverse is not necessarily true.
extraction, transformation, and load (ETL) - Answer -Performing extensive ________ to
move data to the data warehouse may be a sign of poorly managed data and a
fundamental lack of a coherent data management strategy.
False - Answer -OLTP systems are designed to handle ad hoc analysis and complex
queries that deal with many data items.
improved customer service - Answer -Data warehouses provide direct and indirect
benefits to organizations. Which of the following is an indirect benefit of data
warehouses?
Enterprise application integration - Answer -________ is a mechanism that integrates
application functionality and shares functionality (rather than data) across systems,
thereby enabling flexibility and reuse.
All of the following are true about in-database processing technology EXCEPT -
Answer -it pushes the algorithms to where the data is.
it makes the response to queries much faster than conventional databases.
it is often used for apps like credit card fraud detection and investment risk
management.
***it is the same as in-memory storage technology***
three-tier architecture. - Answer -A Web client that connects to a Web server, which is
in turn connected to a BI application server, is reflective of a
False - Answer -User-initiated navigation of data through disaggregation is referred to
as "drill up."
hub-and-spoke data warehouse architecture - Answer -Which data warehouse
architecture uses a normalized relational warehouse that feeds multiple data marts?
True - Answer -The hub-and-spoke data warehouse model uses a centralized
warehouse feeding dependent data marts.
, Inmon - Answer -The ________ Model, also known as the EDW approach, emphasizes
top-down development, employing established database development methodologies
and tools, such as entity-relationship diagrams (ERD), and an adjustment of the spiral
development approach.
Transaction processing - Answer -Online ________ is a term used for a transaction
system that is primarily responsible for capturing and storing data related to day-to-day
business functions such as ERP, CRM, SCM, and point of sale.
parallel processing - Answer -Which of the following BEST enables a data warehouse
to handle complex queries and scale up to handle many more requests?
star schema - Answer -When representing data in a data warehouse, using several
dimension tables that are each connected only to a fact table means you are using
which warehouse structure?
Mention briefly some of the recently popularized concepts and technologies that will
play a significant role in defining the future of data warehousing. - Answer -Sourcing
(mechanisms for acquisition of data from diverse and dispersed sources):
o Web, social media, and Big Data
o Open source software
o SaaS (software as a service)
o Cloud computing
• Infrastructure (architectural—hardware and software—enhancements):
o Columnar (a new way to store and access data in the database)
o Real-time data warehousing
o Data warehouse appliances (all-in-one solutions to DW)
o Data management technologies and practices
o In-database processing technology (putting the algorithms where the data is)
o In-memory storage technology (moving the data in the memory for faster processing)
o New database management systems
o Advanced analytics
federated - Answer -The ________ data warehouse architecture involves integrating
disparate systems and analytical resources from multiple sources to meet changing
needs or business conditions.
What are the four processes that define a closed-loop BPM cycle? - Answer -The four
processes that define a closed-loop BPM cycle are:
1. Strategize: Where do we want to go?
2. Plan: How do we get there?
3. Monitor/Analyze: How are we doing?
