BCIS 461 Exam 2 Ch 3
Why is a performance management system superior to a performance measurement system?
because measurement alone has little use without action
Six Sigma Performance Measurement System has all of the following characteristics, EXCEPT A. Includes all business process B. Identifies measures that drive performance C. Emphasizes targets for each measurement D. Emphasizes learning and innovation
C. Emphasizes targets for each measurement
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?
star schema
Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are
subject-oriented and nonvolatile
A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a
three-tier architecture
A large storage location that can hold vast quantities of data (mostly unstructured) in its native/raw format for future/potential analytics consumption is referred to as a(n)
Data Lake
The three main types of data warehouses are data marts, operational _______ ________, and enterprise data warehouses.
Data Stores
The role responsible for successful administration and management of a data warehouse is the _______ _______ _______ , who should be familiar with high-performance software, hardware, and networking technologies, and also possesses solid business insight.
Data warehouse administrator
BSC Performance Management System has a heavy emphasis on maximizing profitability.
False
Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software.
False
Lagging Indicators measure activities that have a significant impact on outcome KPIs
False
Moving the data into a data warehouse is usually the easiest part of its creation.
False
OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items.
False
Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses.
False
Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks.
False
The BPM development cycle is essentially a one-shot process where the requirement is to get it right the first time.
False
Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones.
False
User-initiated navigation of data through disaggregation is referred to as "drill up."
False
Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?
Independent data mart
The DMAIC performance improvement model all of the following steps, EXCEPT Define Monitor Control Improve
Monitor
________ describe the structure and meaning of the data, contributing to their effective use.
NOT meta data
Given that the size of data warehouses is expanding at an exponential rate, ________ is an important issue.
Scalability
Real-time data warehousing can be used to support the highest level of decision making sophistication and power. The major feature that enables this in relation to handling the data is
Speed of data transfer
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.
Transaction Processing
Learning is one of the BSC Performance Management System organizational view.
True
With key performance indicators, driver KPIs have a significant effect on outcome KPIs, but the reverse is not necessarily true.
True
Without middleware, different BI programs cannot easily connect to the data warehouse.
True
KPIs have all of the following distinguish criteria, EXCEPT A. Ranges B. Encodings C. Targets D. Benchmarks E. Limits
E. Limits
________ is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases.
Enterprise information integration (EII)
What is Six Sigma?
a methodology aimed at reducing the number of defects in a business process