BI EXAM 1 REVIEW QUESTIONS & ANSWERS
The growth in hardware, software, and network capacities has had little impact on
modern BI innovations. - Answer -False
________ is an umbrella term that combines architectures, tools, databases, analytical
tools, applications, and methodologies. - Answer -Business intelligence (BI)
________ cycle times are now extremely compressed, faster, and more informed
across industries. - Answer -Business
Data generation is a precursor, and is not included in the analytics ecosystem. -
Answer -False
The user interface of a BI system is often referred to as a(n) ________. - Answer -
dashboard
As the number of potential BI applications increases, the need to justify and prioritize
them arises. This is not an easy task due to the large number of ________ benefits. -
Answer -intangible
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 - Answer -D. Locally concentrated workforces
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 - Answer -C. data monitoring
BI represents a bold new paradigm in which the company's business strategy must be
aligned to its business intelligence analysis initiatives. - Answer -False
Describe and define Big Data. Why is a search engine a Big Data application? -
Answer -Big Data is data that cannot be stored in a single storage unit. Big Data
typically refers to data that is arriving in many different forms, be they structured,
unstructured, or in a stream. Major sources of such data are clickstreams from Web
sites, postings on social media sites such as Facebook, or data from traffic, sensors, or
weather.
,A Web search engine such as Google needs to search and index billions of Web pages
in order to give you relevant search results in a fraction of a second. Although this is not
done in real time, generating an index of all the Web pages on the Internet is not an
easy task.
Business intelligence (BI) is a specific term that describes architectures and tools only. -
Answer -False
The Google search engine is an example of Big Data in that it has to search and index
billions of ________ in fractions of a second for each search. - Answer -web pages
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 - Answer -D. Pure Big Data
systems do not involve fault tolerance
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 - Answer -B. prescriptive
What storage system and processing algorithm were developed by Google for Big
Data? - Answer -Google developed and released as an Apache project the Hadoop
Distributed File System (HDFS) for storing large amounts of data in a distributed way.
Google developed and released as an Apache project the MapReduce algorithm for
pushing computation to the data, instead of pushing data to a computing node.
Different types of players are identified and described in the analytics ________. -
Answer -ecosystem
Demands for instant, on-demand access to dispersed information decrease as firms
successfully integrate BI into their operations. - Answer -False
Decision support system (DSS) and management information system (MIS) have
precise definitions agreed to by practitioners. - Answer -False
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 - Answer -D. BI
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. - Answer -True
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 - Answer -C. executive information systems
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 - Answer -
C. the processing power needed for the centralized model would overload a single
computer
Relational databases began to be used in the
A. 1960s
B. 1970s
C. 1980s
D. 1990s - Answer -C. 1980s
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. - Answer -
C. a distinct system that provides storage for data that will be made use of in analysis.
BI applications must be integrated with
A. databases
B. legacy systems
C. enterprise systems
D. all of the above - Answer -D. all of the above
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 - Answer -B. heat maps
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. - Answer
-True
In what decade did disjointed information systems begin to be integrated?
A. 1970s
B. 1980s
C. 1990s
D. 2000s - Answer -B. 1980s
What type of analytics seeks to determine what is likely to happen in the future?
A. descriptive
B. prescriptive
C. predictive
D. domain - Answer -C. predictive
Fundamental reasons for investing in BI must be ________ with the company's
business strategy. - Answer -aligned
In the Opening Vignette on Sports Analytics, what was adjusted to drive one-time ticket
sales?
A. player selections
B. stadium locations
C. fan tweets
D. ticket prices - Answer -D. ticket prices
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 - Answer -C. the more pressing need to close the gap between the
operational data and strategic objectives
A(n) ________ is a major component of a Business Intelligence (BI) system that is often
browser based and often presents a portal or dashboard. - Answer -user interface
The growth in hardware, software, and network capacities has had little impact on
modern BI innovations. - Answer -False
________ is an umbrella term that combines architectures, tools, databases, analytical
tools, applications, and methodologies. - Answer -Business intelligence (BI)
________ cycle times are now extremely compressed, faster, and more informed
across industries. - Answer -Business
Data generation is a precursor, and is not included in the analytics ecosystem. -
Answer -False
The user interface of a BI system is often referred to as a(n) ________. - Answer -
dashboard
As the number of potential BI applications increases, the need to justify and prioritize
them arises. This is not an easy task due to the large number of ________ benefits. -
Answer -intangible
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 - Answer -D. Locally concentrated workforces
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 - Answer -C. data monitoring
BI represents a bold new paradigm in which the company's business strategy must be
aligned to its business intelligence analysis initiatives. - Answer -False
Describe and define Big Data. Why is a search engine a Big Data application? -
Answer -Big Data is data that cannot be stored in a single storage unit. Big Data
typically refers to data that is arriving in many different forms, be they structured,
unstructured, or in a stream. Major sources of such data are clickstreams from Web
sites, postings on social media sites such as Facebook, or data from traffic, sensors, or
weather.
,A Web search engine such as Google needs to search and index billions of Web pages
in order to give you relevant search results in a fraction of a second. Although this is not
done in real time, generating an index of all the Web pages on the Internet is not an
easy task.
Business intelligence (BI) is a specific term that describes architectures and tools only. -
Answer -False
The Google search engine is an example of Big Data in that it has to search and index
billions of ________ in fractions of a second for each search. - Answer -web pages
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 - Answer -D. Pure Big Data
systems do not involve fault tolerance
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 - Answer -B. prescriptive
What storage system and processing algorithm were developed by Google for Big
Data? - Answer -Google developed and released as an Apache project the Hadoop
Distributed File System (HDFS) for storing large amounts of data in a distributed way.
Google developed and released as an Apache project the MapReduce algorithm for
pushing computation to the data, instead of pushing data to a computing node.
Different types of players are identified and described in the analytics ________. -
Answer -ecosystem
Demands for instant, on-demand access to dispersed information decrease as firms
successfully integrate BI into their operations. - Answer -False
Decision support system (DSS) and management information system (MIS) have
precise definitions agreed to by practitioners. - Answer -False
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 - Answer -D. BI
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. - Answer -True
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 - Answer -C. executive information systems
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 - Answer -
C. the processing power needed for the centralized model would overload a single
computer
Relational databases began to be used in the
A. 1960s
B. 1970s
C. 1980s
D. 1990s - Answer -C. 1980s
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. - Answer -
C. a distinct system that provides storage for data that will be made use of in analysis.
BI applications must be integrated with
A. databases
B. legacy systems
C. enterprise systems
D. all of the above - Answer -D. all of the above
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 - Answer -B. heat maps
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. - Answer
-True
In what decade did disjointed information systems begin to be integrated?
A. 1970s
B. 1980s
C. 1990s
D. 2000s - Answer -B. 1980s
What type of analytics seeks to determine what is likely to happen in the future?
A. descriptive
B. prescriptive
C. predictive
D. domain - Answer -C. predictive
Fundamental reasons for investing in BI must be ________ with the company's
business strategy. - Answer -aligned
In the Opening Vignette on Sports Analytics, what was adjusted to drive one-time ticket
sales?
A. player selections
B. stadium locations
C. fan tweets
D. ticket prices - Answer -D. ticket prices
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 - Answer -C. the more pressing need to close the gap between the
operational data and strategic objectives
A(n) ________ is a major component of a Business Intelligence (BI) system that is often
browser based and often presents a portal or dashboard. - Answer -user interface
