Test 1 Data CH 1
Relational databases began to be used in the A) 1960s. B) 1970s. C) 1980s. D) 1990s.
C
Computer applications have moved from transaction processing and monitoring activities to problem analysis and solution applications.
TRUE
In the 2000s, the DW-driven DSSs began to be called BI systems.
TRUE
The very design that makes an OLTP system efficient for transaction processing makes it inefficient for A) end-user ad hoc reports, queries, and analysis. B) transaction processing systems that constantly update operational databases. C) the collection of reputable sources of intelligence. D) transactions such as ATM withdrawals, where we need to reduce a bank balance accordingly.
A
How are enterprise resources planning (ERP) systems related to supply chain management (SCM) systems? A) different terms for the same system B) complementary systems C) mutually exclusive systems D) none of the above; these systems never interface
B
In what decade did disjointed information systems begin to be integrated? A) 1970s B) 1980s C) 1990s D) 2000s
B
BI applications must be integrated with A) databases. B) legacy systems. C) enterprise systems. D) all of these
D
In the Opening Vignette on Sports Analytics, what was adjusted to drive one-time ticket sales? A) player selections B) stadium location C) fan tweets D) ticket prices
D
Which of the following developments is NOT contributing to facilitating growth of decision support and analytics? A) collaboration technologies B) Big Data C) knowledge management systems D) locally concentrated workforces
D
Which of the following is an umbrella term that combines architectures, tools, databases, analytical tools, applications, and methodologies? A) MIS B) DSS C) ERP D) BI
D
BI represents a bold new paradigm in which the company's business strategy must be aligned to its business intelligence analysis initiatives.
FALSE
Business intelligence (BI) is a specific term that describes architectures and tools only.
FALSE
Computerized support is only used for organizational decisions that are responses to external pressures, not for taking advantage of opportunities.
FALSE
Data generation is a precursor, and is not included in the analytics ecosystem.
FALSE
During the early days of analytics, data was often obtained from the domain experts using manual processes to build mathematical or knowledge-based models.
TRUE
Managing data warehouses requires special methods, including parallel computing and/or Hadoop/Spark.
TRUE
Successful BI is a tool for the information systems department, but is not exposed to the larger organization.
FALSE
Which of the following statements about Big Data is true? A) Data chunks are stored in different locations on one computer. B) Hadoop is a type of processor used to process Big Data applications. C) MapReduce is a storage filing system. D) Pure Big Data systems do not involve fault tolerance.
D
In the Opening Vignette on Sports Analytics, what type of modeling was used to predict offensive tactics? A) heuristics B) heat maps C) cascaded decision trees D) sentiment analysis
B
The competitive imperatives for BI include all of the following EXCEPT A) right information B) right user C) right time D) right place
B
Today, many vendors offer diversified tools, some of which are completely preprogrammed (called shells). How are these shells utilized? A) They are used for customization of BI solutions. B) All a user needs to do is insert the numbers. C) The shell provides a secure environment for the organization's BI data. D) They host an enterprise data warehouse that can assist in decision making.
B
What type of analytics seeks to recognize what is going on as well as the likely forecast and make decisions to achieve the best performance possible? A) descriptive B) prescriptive C) predictive D) domain
B
Big Data often involves a form of distributed storage and processing using Hadoop and MapReduce. One reason for this is A) centralized storage creates too many vulnerabilities. B) the "Big" in Big Data necessitates over 10,000 processing nodes. C) the processing power needed for the centralized model would overload a single computer. D) Big Data systems have to match the geographical spread of social media.
C
Business applications have moved from transaction processing and monitoring to other activities. Which of the following is NOT one of those activities? A) problem analysis B) solution applications C) data monitoring D) mobile access
C
Online transaction processing (OLTP) systems handle a company's routine ongoing business. In contrast, a data warehouse is typically A) the end result of BI processes and operations. B) a repository of actionable intelligence obtained from a data mart. C) a distinct system that provides storage for data that will be made use of in analysis. D) an integral subsystem of an online analytical processing (OLAP) system.
C
The need for more versatile reporting than what was available in 1980s era ERP systems led to the development of what type of system? A) management information systems B) relational databases C) executive information systems D) data warehouses
C
What has caused the growth of the demand for instant, on-demand access to dispersed information? A) the increasing divide between users who focus on the strategic level and those who are more oriented to the tactical level B) the need to create a database infrastructure that is always online and contains all the information from the OLTP systems C) the more pressing need to close the gap between the operational data and strategic objectives D) the fact that BI cannot simply be a technical exercise for the information systems department
C
What type of analytics seeks to determine what is likely to happen in the future? A) descriptive B) prescriptive C) predictive D) domain
C
Which of the following is NOT an example of transaction processing? A) ATM withdrawal B) bank deposit C) sales report D) cash register scans
C
Decision support system (DSS) and management information system (MIS) have precise definitions agreed to by practitioners.
FALSE
Demands for instant, on-demand access to dispersed information decrease as firms successfully integrate BI into their operations.
FALSE
Due to industry consolidation, the analytics ecosystem consists of only a handful of players across several functional areas.
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.
FALSE
Major commercial business intelligence (BI) products and services were well established in the early 1970s.
FALSE
Managing information on operations, customers, internal procedures and employee interactions is the domain of cognitive science.
FALSE
The growth in hardware, software, and network capacities has had little impact on modern BI innovations.
FALSE
The use of dashboards and data visualizations is seldom effective in identifying issues in organizations, as demonstrated by the Silvaris Corporation Case Study.
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.
TRUE
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.
TRUE
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.
TRUE
