Business Intelligence, Analytics, Data Science & AI –
Comprehensive Strategies, Data-Driven Decision-
Making, Predictive Analytics, Machine Learning &
Emerging Technology Review
SUMMARIZED EXAM COVERAGE
All Topics Covered
The examination encompasses comprehensive coverage of Business Intelligence (BI) systems and their
evolution, data warehousing concepts and architectures, online transaction processing (OLTP) versus
online analytical processing (OLAP), the analytics ecosystem and its key players, descriptive, predictive,
and prescriptive analytics methodologies, Big Data characteristics and processing techniques (Volume,
Variety, Velocity), data mining and analytical modeling approaches, decision support systems (DSS),
expert systems, and knowledge management, business performance management and dashboards,
data visualization techniques, cognitive limitations and computer-based decision support, Gartner's BI
implementation framework, retail analytics applications including market basket analysis, customer
segmentation, price elasticity, and inventory optimization, healthcare analytics applications,
MapReduce and Hadoop distributed processing, real-time BI and intelligent agents, Web services and
RFID impacts, the analytics hierarchy and historical progression from MIS to DSS to ESS to BI, data
service providers and analytics ecosystem stakeholders, and emerging trends in data science, machine
learning, and artificial intelligence applications in business decision-making.
This comprehensive examination covers the complete spectrum of Business Intelligence, Analytics, Data
Science, and Artificial Intelligence topics, with randomized questions designed to test understanding of
key concepts, applications, and emerging trends in data-driven decision-making.
EXAMINATION
MULTIPLE-CHOICE QUESTIONS
,2
Question 1
An FDNY permit is required for aerosol products in excess of which weight threshold?
A. 50 pounds
B. 75 pounds
C. 100 pounds
D. 200 pounds
Correct Answer: C
RATIONALE: A Certificate of Fitness (A-49) is required for any location with 100 pounds (1,600 ounces) or
more of aerosols in any number or type of containers; this threshold triggers the need for both a permit
and a Certificate of Fitness holder to supervise the storage, handling, and use of these products.
Question 2
Which of the following represents the primary difference between Management Information Systems
(MIS) and Decision Support Systems (DSS)?
A. MIS provides real-time data while DSS only offers historical reports
B. MIS provides reports on business functions while DSS adds the ability to use data with models for
unstructured problems
C. MIS focuses on external data while DSS focuses exclusively on internal data
D. MIS requires expert knowledge while DSS is automated
Correct Answer: B
RATIONALE: Management information systems (MIS) provided reports on various aspects of business
functions using captured information, while decision support systems (DSS) added the ability to use data
with models to address unstructured problems, representing a significant advancement in analytical
capabilities.
Question 3
,3
What processing technique is specifically applied to process Big Data when traditional computing
methods are insufficient?
A. Sequential processing
B. MapReduce programming paradigm
C. Linear regression processing
D. Centralized database processing
Correct Answer: B
RATIONALE: One computer, even a powerful one, could not handle the scale of Big Data; the solution is to
push computation to the data using the MapReduce programming paradigm, which distributes
processing across multiple nodes rather than moving large datasets to a single computing location.
Question 4
Which of the following best defines Business Intelligence (BI) in its broad definition?
A. A single software application for financial reporting
B. An umbrella term that combines architectures, tools, databases, analytical tools, applications, and
methodologies
C. A database management system specifically for transaction processing
D. A hardware infrastructure for storing customer data
Correct Answer: B
RATIONALE: Business Intelligence (BI) is an umbrella term that combines architectures, tools, databases,
analytical tools, applications, and methodologies, with its major objective being to enable interactive
access to data, enable manipulation of these data, and provide business managers and analysts the
ability to conduct appropriate analysis.
Question 5
What are the three Vs that characterize Big Data?
, 4
A. Volume, Value, and Validity
B. Volume, Variety, and Velocity
C. Validity, Variety, and Velocity
D. Volume, Veracity, and Value
Correct Answer: B
RATIONALE: Today Big Data refers to almost any kind of large data that has the characteristics of volume
(large scale), velocity (high speed of generation), and variety (multiple data types including structured
and unstructured formats), such as Web searches, financial trading data, and social media postings.
Question 6
What type of analytics aims to determine what is likely to happen in the future by looking at past data?
A. Descriptive analytics
B. Predictive analytics
C. Prescriptive analytics
D. Diagnostic analytics
Correct Answer: B
RATIONALE: Predictive analytics is the use of statistical techniques and data mining to determine what is
likely to happen in the future; businesses use it to forecast whether customers are likely to switch to a
competitor, what customers are likely to buy, and how likely customers are to respond to a promotion.
Question 7
Which of the following is NOT a major component of a Business Intelligence (BI) system?
A. Data warehouse with source data
B. Business analytics collection of tools
C. Online transaction processing system
D. User interface for data visualization
Correct Answer: C