CIS 405 Final Exam ACTUAL QUESTIONS
AND CORRECT ANSWERS
BI information delivery through "visualization" means displaying the information through a visually-
oriented means such as a "heat map rather than a tabular form. - CORRECT ANSWER True
On a BI dashboard, only tabular and graphical displays of data are permitted; you would never find a
geospatial visualization as part of a dashboard - CORRECT ANSWER False
Consider the following BI functionality: "Right now it's August, 2022. Last month we increased
prices by 5% for all of our weight loss programs; how is that affecting this month's sales?!
The above is an example of what type (or "flavor") of business intelligence? - CORRECT
ANSWER Tell me what is happening right now
According to the lecture material, which of the following was one of the two significant advances
right around 1990 that kicked off the modern business intelligence era? - CORRECT
ANSWER None of the above is correct
Data mining is best thought of as a related discipline to, or even a subset of, business intelligence. -
CORRECT ANSWER True
According to the textbook, the retail sector has been relatively fast to adapt analytics. - CORRECT
ANSWER True
Organizations can use customer-facing business intelligence in business/commercial settings (e.g.,
banking, retail, online e-commerce, etc.) but not in government settings. - CORRECT
ANSWER False
If a call center manager is studying a list of products that customers have bought in the past year as
well as those customers' demographic data, and if this analysis is intended to be used in the company's
next annual planning cycle to possibly realign sales territories, this is an example of both: -
CORRECT ANSWER internal-facing BI and strategic BI
, If you are using a data warehouse for operational business intelligence capabilities, data usually
makes its way from source systems into the data warehouse at the same "velocity" (e.g., frequency of
updates) as would be needed for strategic BI purposes. - CORRECT ANSWER False
Which of the following statements is most true about the CenterPoint Energy case described in the
textbook? - CORRECT ANSWER CenterPoint makes use of sentiment analysis as part of their
customer experience analytics
According to the textbook, text mining is a typical enabler of
analytics. - CORRECT ANSWER Predictive
According to course material, which of the following is not part of an overall analytics ecosvstem? -
CORRECT ANSWER All of the above are found in an analvtics ecosystem
In the Perfect Order Index (POI) case, the majority of packing problems are detected and registered in
the POI before shipping boxes leave the Distribution Center (DC). - CORRECT
ANSWER False
The term "data lake" is synonymous and interchangeable with "data warehouse." - CORRECT
ANSWER False
In our Perfect Order Index case, several dimensions were considered to be "special cases" because
they weren't regularly loaded and refreshed with new data, but instead didn't change over time. Which
of the following is/are one of those "special case" dimensions? - CORRECT ANSWER None
A scalable data warehouse means the following:
When more than several hundred terabytes of data needs to be stored, you may need to consider
additional data management capabilities such as parallel processing or special indexing to maintain
adequate data access and query performance. - CORRECT ANSWER True
In our "Perfect Order Index" example, the data warehouse only used the initial ETL jobs to load the
data, no refresh/incremental ETL was needed. - CORRECT ANSWER False
A "columnar database" uses the exact same architecture and technology as a standard "relational
database" - the two terms are interchangeable. - CORRECT ANSWER False
AND CORRECT ANSWERS
BI information delivery through "visualization" means displaying the information through a visually-
oriented means such as a "heat map rather than a tabular form. - CORRECT ANSWER True
On a BI dashboard, only tabular and graphical displays of data are permitted; you would never find a
geospatial visualization as part of a dashboard - CORRECT ANSWER False
Consider the following BI functionality: "Right now it's August, 2022. Last month we increased
prices by 5% for all of our weight loss programs; how is that affecting this month's sales?!
The above is an example of what type (or "flavor") of business intelligence? - CORRECT
ANSWER Tell me what is happening right now
According to the lecture material, which of the following was one of the two significant advances
right around 1990 that kicked off the modern business intelligence era? - CORRECT
ANSWER None of the above is correct
Data mining is best thought of as a related discipline to, or even a subset of, business intelligence. -
CORRECT ANSWER True
According to the textbook, the retail sector has been relatively fast to adapt analytics. - CORRECT
ANSWER True
Organizations can use customer-facing business intelligence in business/commercial settings (e.g.,
banking, retail, online e-commerce, etc.) but not in government settings. - CORRECT
ANSWER False
If a call center manager is studying a list of products that customers have bought in the past year as
well as those customers' demographic data, and if this analysis is intended to be used in the company's
next annual planning cycle to possibly realign sales territories, this is an example of both: -
CORRECT ANSWER internal-facing BI and strategic BI
, If you are using a data warehouse for operational business intelligence capabilities, data usually
makes its way from source systems into the data warehouse at the same "velocity" (e.g., frequency of
updates) as would be needed for strategic BI purposes. - CORRECT ANSWER False
Which of the following statements is most true about the CenterPoint Energy case described in the
textbook? - CORRECT ANSWER CenterPoint makes use of sentiment analysis as part of their
customer experience analytics
According to the textbook, text mining is a typical enabler of
analytics. - CORRECT ANSWER Predictive
According to course material, which of the following is not part of an overall analytics ecosvstem? -
CORRECT ANSWER All of the above are found in an analvtics ecosystem
In the Perfect Order Index (POI) case, the majority of packing problems are detected and registered in
the POI before shipping boxes leave the Distribution Center (DC). - CORRECT
ANSWER False
The term "data lake" is synonymous and interchangeable with "data warehouse." - CORRECT
ANSWER False
In our Perfect Order Index case, several dimensions were considered to be "special cases" because
they weren't regularly loaded and refreshed with new data, but instead didn't change over time. Which
of the following is/are one of those "special case" dimensions? - CORRECT ANSWER None
A scalable data warehouse means the following:
When more than several hundred terabytes of data needs to be stored, you may need to consider
additional data management capabilities such as parallel processing or special indexing to maintain
adequate data access and query performance. - CORRECT ANSWER True
In our "Perfect Order Index" example, the data warehouse only used the initial ETL jobs to load the
data, no refresh/incremental ETL was needed. - CORRECT ANSWER False
A "columnar database" uses the exact same architecture and technology as a standard "relational
database" - the two terms are interchangeable. - CORRECT ANSWER False
