Computerized support is only used for organizational decisions that are responses to external pressures, not for taking advantage of opportunities. T/F
Answer: False
The complexity of today's business environment creates many new challenges for organizations, such as global competition, but creates few new opportunities in return. T/F
Answer: False
In addition to deploying business intelligence (BI) systems, companies may also perform other actions to counter business pressures, such as improving customer service and entering business alliances. T/F
Answer: True
The overwhelming majority of competitive actions taken by businesses today feature computerized information system support. T/F
Answer: True
The access to data and ability to manipulate data (frequently including real-time data) are key elements of business intelligence (BI) systems. T/F
Answer: True
One of the four components of BI systems, business performance management, is a collection of source data in the data warehouse. T/F
Answer: False
Actionable intelligence is the primary goal of modern-day Business Intelligence (BI) systems vs. historical reporting that characterized Management Information Systems (MIS). T/F
Answer: True
Data warehouse and BI initiatives typically follow a process similar to that used in military intelligence initiatives. T/F
Answer: True
The two critical partnerships required for BI governance are (a) a partnership between functional area users and/or product/service area employees, and (b) a partnership between representatives of the marketing and vendor sides. T/F
Answer: False
The term intelligence in a BI context is used to describe clandestine operations dedicated to stealing corporate secrets, in the manner of the government's CIA and other covert agencies. T/F
Answer: False
Information systems that support such transactions as ATM withdrawals, bank deposits, and cash register scans at the grocery store represent transaction processing, a critical branch of BI. T/F
Answer: False
Many business users in the 1980s referred to their mainframes as "the black hole," because all the information went into it, but little ever came back and ad hoc real-time querying was virtually impossible. T/F
Answer: True
The success of BI is assured not because of which personnel would be the most likely to use it, but as a result of pervasive adoption across the organization. T/F
Answer: False
BI represents a bold new paradigm in which the company's business strategy must be aligned to its business intelligence analysis initiatives. T/F
Answer: False
Traditional BI systems use a large volume of static data that has been extracted, cleansed, and loaded into a data warehouse to produce reports and analyses. T/F
Answer: True
Almost all BI applications are constructed with shells provided by an outsourcing provider who may themselves create a custom solution for a vendor or work with another client. T/F
Answer: False
The use of dashboards and data visualizations is seldom effective in finding efficiencies in organizations, as demonstrated by the Seattle Children's Hospital Case Study. T/F
Answer: False
The use of statistics in baseball by the Oakland Athletics, as described in the Moneyball case study, is an example of the effectiveness of prescriptive analytics. T/F
Answer: True
Pushing programming out to distributed data is achieved solely by using the Hadoop Distributed File System or HDFS. T/F
Answer: False
Volume, velocity, and variety of data characterize the Big Data paradigm. T/F
Answer: True
In the Isle of Capri case, the only capability added by the new software was increased processing speed of processing reports. T/F
Answer: False
The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization. T/F
Answer: True
Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks. T/F
Answer: False
Data warehouses are subsets of data marts. T/F
Answer: False
One way an operational data store differs from a data warehouse is the recency of their data. T/F
Answer: True
Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses. T/F
Answer: False
Without middleware, different BI programs cannot easily connect to the data warehouse. T/F
Answer: True
Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones. T/F
Answer: False
Moving the data into a data warehouse is usually the easiest part of its creation. T/F
Answer: False
The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts. T/F
Answer: True
Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them. T/F
Answer: True
Bill Inmon advocates the data mart bus architecture whereas Ralph Kimball promotes the hub-and-spoke architecture, a data mart bus architecture with conformed dimensions. T/F
Answer: False
The ETL process in data warehousing usually takes up a small portion of the time in a data-centric project. T/F
Answer: False
In the Starwood Hotels case, up-to-date data and faster reporting helped hotel managers better manage their occupancy rates. T/F
Answer: True
Large companies, especially those with revenue upwards of $500 million consistently reap substantial cost savings through the use of hosted data warehouses. T/F
Answer: False
OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items. T/F
Answer: False
The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage. T/F
Answer: True
A well-designed data warehouse means that user requirements do not have to change as business needs change. T/F
Answer: False
Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure. T/F
Answer: False
Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software. T/F
Answer: False