BSAN 160 EXAM REVIEW QUESTIONS AND ANSWERS
T or F:Decision support system are computer-based support systems that integrate individuals' expertise
and computer capabilities, and they have precise definitions agreed to by practitioners. - CORRECT
ANSWER✅✅✅False
Business Intelligence (BI) - CORRECT ANSWER✅✅✅is an umbrella term that combines architectures,
databases, analytical tools, applications, and methodologies
T or F: Data is a collection of observations, experiments, and experiences that do not necessarily
represent absolute facts that are universally true. - CORRECT ANSWER✅✅✅True
Descriptive Analytics - CORRECT ANSWER✅✅✅help managers understand current events in the
organization including causes, trends, and patterns.
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? - CORRECT ANSWER✅✅✅Prescriptive
Which of the following is/are predictive analytics method(s)?
A)Boxplot B)Text analysis C)Simulation D)Regression analysis, E)Clustering B, D and EB, C and ED and E -
CORRECT ANSWER✅✅✅B, D, E
Using characteristics of first year undergraduate students, such as age, gender, major, location,
workout/sports activities, if we developed a model to forecast which students are at risk of dropping out
after the first year of college, decided which students to reach out to and offered them support services
to reduce their risk of dropping out, what kind of analytics application would this work represent? -
CORRECT ANSWER✅✅✅prescriptive analytics
Which chart type below would be most helpful to show the comparison between worldwide turnover
rate compared with tech sector turnover rate?
Line chart
Histogram
Bar chart
, Scatterplot - CORRECT ANSWER✅✅✅Bar chart
Which chart type below would be most helpful to show the relative proportions of turnover rate of
different categories (e.g., computer games, Internet, computer software and other) within the tech
sector that drive tech turnover the most?
Histogram
Pie chart
Bar chart
Scatterplot - CORRECT ANSWER✅✅✅Pie Chart
T or F: Original (raw) data is usually collected from multiple data sources including various formats, and
it is readily usable by analytics tools and algorithms - CORRECT ANSWER✅✅✅False
T or F: During data transformation, depending on the context and purpose of preprocessing the data can
be rescaled to a fixed range, and numeric variables can be converted to categorical variables - CORRECT
ANSWER✅✅✅True
T or F: Data reduction can be applied to rows (observations) and/or columns (variables) in a given
dataset - CORRECT ANSWER✅✅✅True
T or F: In data preprocessing step to reduce the dimension of data prior to analysis, sampling the rows is
more complex than selecting the columns (variables - CORRECT ANSWER✅✅✅False
T or F: Choice of visualization method that meets the presentation requirements for a given data
depends on the data types available, purpose of the visual and context - CORRECT
ANSWER✅✅✅True
Which of the below is not a data preprocessing step?
data consolidation
data transformation
data separation
T or F:Decision support system are computer-based support systems that integrate individuals' expertise
and computer capabilities, and they have precise definitions agreed to by practitioners. - CORRECT
ANSWER✅✅✅False
Business Intelligence (BI) - CORRECT ANSWER✅✅✅is an umbrella term that combines architectures,
databases, analytical tools, applications, and methodologies
T or F: Data is a collection of observations, experiments, and experiences that do not necessarily
represent absolute facts that are universally true. - CORRECT ANSWER✅✅✅True
Descriptive Analytics - CORRECT ANSWER✅✅✅help managers understand current events in the
organization including causes, trends, and patterns.
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? - CORRECT ANSWER✅✅✅Prescriptive
Which of the following is/are predictive analytics method(s)?
A)Boxplot B)Text analysis C)Simulation D)Regression analysis, E)Clustering B, D and EB, C and ED and E -
CORRECT ANSWER✅✅✅B, D, E
Using characteristics of first year undergraduate students, such as age, gender, major, location,
workout/sports activities, if we developed a model to forecast which students are at risk of dropping out
after the first year of college, decided which students to reach out to and offered them support services
to reduce their risk of dropping out, what kind of analytics application would this work represent? -
CORRECT ANSWER✅✅✅prescriptive analytics
Which chart type below would be most helpful to show the comparison between worldwide turnover
rate compared with tech sector turnover rate?
Line chart
Histogram
Bar chart
, Scatterplot - CORRECT ANSWER✅✅✅Bar chart
Which chart type below would be most helpful to show the relative proportions of turnover rate of
different categories (e.g., computer games, Internet, computer software and other) within the tech
sector that drive tech turnover the most?
Histogram
Pie chart
Bar chart
Scatterplot - CORRECT ANSWER✅✅✅Pie Chart
T or F: Original (raw) data is usually collected from multiple data sources including various formats, and
it is readily usable by analytics tools and algorithms - CORRECT ANSWER✅✅✅False
T or F: During data transformation, depending on the context and purpose of preprocessing the data can
be rescaled to a fixed range, and numeric variables can be converted to categorical variables - CORRECT
ANSWER✅✅✅True
T or F: Data reduction can be applied to rows (observations) and/or columns (variables) in a given
dataset - CORRECT ANSWER✅✅✅True
T or F: In data preprocessing step to reduce the dimension of data prior to analysis, sampling the rows is
more complex than selecting the columns (variables - CORRECT ANSWER✅✅✅False
T or F: Choice of visualization method that meets the presentation requirements for a given data
depends on the data types available, purpose of the visual and context - CORRECT
ANSWER✅✅✅True
Which of the below is not a data preprocessing step?
data consolidation
data transformation
data separation
