MIS 301: Exam II Study Guide
Questions with Guaranteed Pass
Solutions 2026-2027 Update.
Online Analytical Processing (OLAP) - Answer A method of querying and reporting that takes
data from standard relational databases, calculates and summarizes the data, and then stores
the data in a special database called a data cube.
Awareness, evaluation, purchase, delivery, after sales - Answer What is the correct order of
channel phases?
data mart - Answer A database or databases focused on addressing the concerns of a specific
problem (e.g., increasing customer retention, improving product quality) or business unit (e.g.,
marketing, engineering).
data cube - Answer A special database used to store data in OLAP reporting.
Inventory Turnover Ratio - Answer The ratio of a company's annual sales to its inventory.
loyalty card - Answer Systems that provide rewards and usage incentives, typically in
exchange for a method that provides a more detailed tracking and recording of customer
activity. In addition to enhancing data collection, loyalty cards can represent a significant
switching cost.
dashboards - Answer A heads-up display of critical indicators that allow managers to get a
graphical glance at key performance metrics.
legacy system - Answer Older information systems that are often incompatible with other
systems, technologies, and ways of conducting business. Incompatible legacy systems can be a
major roadblock to turning data into information, and they can inhibit firm agility, holding back
operational and strategic initiatives.
Genetic Algorithms (GAs) - Answer model building techniques where computers examine
many potential solutions to a problem, iteratively modifying various mathematical models, and
comparing the mutated models to search for a best alternative
data mining - Answer The process of using computers to identify hidden patterns in, and to
build models from, large data sets.
,Omnichannel - Answer Providing customers with a unified experience across customer
channels, which may include online, mobile, catalog, phone, and retail. Pricing,
recommendations, and incentives should reflect a data-driven, accurate, single view of the
customer.
neural networks - Answer An AI system that examines data and hunts down and exposes
patterns, in order to build models to exploit findings.
information - Answer Data presented in a context so that it can answer a question or support
decision making.
knowledge - Answer insight derived from experience and expertise
Big Data - Answer A general term used to describe massive amount of data available to
today's managers.
Analytics - Answer A term describing the extensive use of data, statistical and quantitative
analysis, explanatory and predictive models, and fact-based management to drive decisions and
actions.
canned reports - Answer Reports that provide regular summaries of information in a
predetermined format.
row or record - Answer A row in a database table. Records represent a single instance of
whatever the table keeps track of (e.g., student, faculty, course title).
(column) (field) - Answer A column in a database table. Columns represent each category of
data contained in a record (e.g., first name, last name, ID number, date of birth).
Expert Systems - Answer AI systems that leverage rules or examples to perform a task in a
way that mimics applied human expertise
table or file - Answer A list of data, arranged in columns (fields) and rows (records).
relational database - Answer The most common standard for expressing databases, whereby
tables (files) are related based on common keys.
artificial intelligence - Answer computer software that seeks to reproduce or mimic human
thought, decision making, or brain functions
,e-discovery - Answer The process of identifying and retrieving relevant electronic information
to support litigation efforts.
Business Intelligence - Answer A term combining aspects of reporting, data exploration and
ad hoc queries, and sophisticated data modeling and analysis.
data warehouse - Answer A set of databases designed to support decision making in an
organization.
transaction processing systems (tps) - Answer Systems that record a transaction (some form
of business-related exchange), such as a cash register sale, ATM withdrawal, or product return.
Data - Answer raw facts and figures
transaction - Answer some kind of business exchange
database - Answer A single table or a collection of related tables.
Machine Learning - Answer Leverages massive amounts of data so that computers can act
and improve on their own without additional programming.
Database Administrator (DBA) - Answer Job title focused on directing, performing, or
overseeing activities associated with a database or set of databases. These may include (but not
necessarily be limited to): database design, creation, implementation, maintenance, backup and
recovery, policy setting and enforcement, and security.
data aggregators - Answer Firms that collect and resell data.
ad hoc reporting tools - Answer Tools that put users in control so that they can create custom
reports on an as-needed basis by selecting fields, ranges, summary conditions, and other
parameters.
over-engineer - Answer Build a model with so many variables that the solution arrived at
might only work on the subset of data you've used to create it.
Database Management System (DBMS) - Answer Sometimes called "database software";
software for creating, maintaining, and manipulating data.
, conclusion - Answer which is not a design thinking stage?
a. invent
b. test
c. prototyping
d. conclusion
target a wide audience - Answer what did proctor & gamble not do?
A. create new advertisements
B. develop new products
C. target a wide audience
D. prototype products based on geography
low risk of success - Answer What is not a risk of design thinking?
A. conflict with existing products
B. low risk of success
C. integration throughout entire business ecosystem
D. conflict with traditional strategy making
build an innovative team of leaders - Answer What was one strategy Rodriguez-Pastor did to
transform Interbank?
A. build an innovative team of leaders
B. outsource talent from top colleges
C. model his company off of foreign banks
D. implement employee benefits that rivaled other companies
implement an affordable insurance program for low to middle class citizens - Answer What
did Rodriguez-Pastor not do?
A. collaborate with leading institutes to develop new programs
B. enter the education industry by creating awards and creating his own school
C. stimulate local economies by purchasing goods from its supermarkets
Questions with Guaranteed Pass
Solutions 2026-2027 Update.
Online Analytical Processing (OLAP) - Answer A method of querying and reporting that takes
data from standard relational databases, calculates and summarizes the data, and then stores
the data in a special database called a data cube.
Awareness, evaluation, purchase, delivery, after sales - Answer What is the correct order of
channel phases?
data mart - Answer A database or databases focused on addressing the concerns of a specific
problem (e.g., increasing customer retention, improving product quality) or business unit (e.g.,
marketing, engineering).
data cube - Answer A special database used to store data in OLAP reporting.
Inventory Turnover Ratio - Answer The ratio of a company's annual sales to its inventory.
loyalty card - Answer Systems that provide rewards and usage incentives, typically in
exchange for a method that provides a more detailed tracking and recording of customer
activity. In addition to enhancing data collection, loyalty cards can represent a significant
switching cost.
dashboards - Answer A heads-up display of critical indicators that allow managers to get a
graphical glance at key performance metrics.
legacy system - Answer Older information systems that are often incompatible with other
systems, technologies, and ways of conducting business. Incompatible legacy systems can be a
major roadblock to turning data into information, and they can inhibit firm agility, holding back
operational and strategic initiatives.
Genetic Algorithms (GAs) - Answer model building techniques where computers examine
many potential solutions to a problem, iteratively modifying various mathematical models, and
comparing the mutated models to search for a best alternative
data mining - Answer The process of using computers to identify hidden patterns in, and to
build models from, large data sets.
,Omnichannel - Answer Providing customers with a unified experience across customer
channels, which may include online, mobile, catalog, phone, and retail. Pricing,
recommendations, and incentives should reflect a data-driven, accurate, single view of the
customer.
neural networks - Answer An AI system that examines data and hunts down and exposes
patterns, in order to build models to exploit findings.
information - Answer Data presented in a context so that it can answer a question or support
decision making.
knowledge - Answer insight derived from experience and expertise
Big Data - Answer A general term used to describe massive amount of data available to
today's managers.
Analytics - Answer A term describing the extensive use of data, statistical and quantitative
analysis, explanatory and predictive models, and fact-based management to drive decisions and
actions.
canned reports - Answer Reports that provide regular summaries of information in a
predetermined format.
row or record - Answer A row in a database table. Records represent a single instance of
whatever the table keeps track of (e.g., student, faculty, course title).
(column) (field) - Answer A column in a database table. Columns represent each category of
data contained in a record (e.g., first name, last name, ID number, date of birth).
Expert Systems - Answer AI systems that leverage rules or examples to perform a task in a
way that mimics applied human expertise
table or file - Answer A list of data, arranged in columns (fields) and rows (records).
relational database - Answer The most common standard for expressing databases, whereby
tables (files) are related based on common keys.
artificial intelligence - Answer computer software that seeks to reproduce or mimic human
thought, decision making, or brain functions
,e-discovery - Answer The process of identifying and retrieving relevant electronic information
to support litigation efforts.
Business Intelligence - Answer A term combining aspects of reporting, data exploration and
ad hoc queries, and sophisticated data modeling and analysis.
data warehouse - Answer A set of databases designed to support decision making in an
organization.
transaction processing systems (tps) - Answer Systems that record a transaction (some form
of business-related exchange), such as a cash register sale, ATM withdrawal, or product return.
Data - Answer raw facts and figures
transaction - Answer some kind of business exchange
database - Answer A single table or a collection of related tables.
Machine Learning - Answer Leverages massive amounts of data so that computers can act
and improve on their own without additional programming.
Database Administrator (DBA) - Answer Job title focused on directing, performing, or
overseeing activities associated with a database or set of databases. These may include (but not
necessarily be limited to): database design, creation, implementation, maintenance, backup and
recovery, policy setting and enforcement, and security.
data aggregators - Answer Firms that collect and resell data.
ad hoc reporting tools - Answer Tools that put users in control so that they can create custom
reports on an as-needed basis by selecting fields, ranges, summary conditions, and other
parameters.
over-engineer - Answer Build a model with so many variables that the solution arrived at
might only work on the subset of data you've used to create it.
Database Management System (DBMS) - Answer Sometimes called "database software";
software for creating, maintaining, and manipulating data.
, conclusion - Answer which is not a design thinking stage?
a. invent
b. test
c. prototyping
d. conclusion
target a wide audience - Answer what did proctor & gamble not do?
A. create new advertisements
B. develop new products
C. target a wide audience
D. prototype products based on geography
low risk of success - Answer What is not a risk of design thinking?
A. conflict with existing products
B. low risk of success
C. integration throughout entire business ecosystem
D. conflict with traditional strategy making
build an innovative team of leaders - Answer What was one strategy Rodriguez-Pastor did to
transform Interbank?
A. build an innovative team of leaders
B. outsource talent from top colleges
C. model his company off of foreign banks
D. implement employee benefits that rivaled other companies
implement an affordable insurance program for low to middle class citizens - Answer What
did Rodriguez-Pastor not do?
A. collaborate with leading institutes to develop new programs
B. enter the education industry by creating awards and creating his own school
C. stimulate local economies by purchasing goods from its supermarkets
