BSAN
BSAN 160 Exam Review 2025
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 Ans-False
Business Intelligence (BI) - Correct Ans-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 Ans-True
Descriptive Analytics - Correct Ans-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 Ans-
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 Ans-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 Ans-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 Ans-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 Ans-Pie Chart
BSAN
, BSAN
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 Ans-
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 Ans-True
T or F: Data reduction can be applied to rows (observations) and/or columns (variables)
in a given dataset - Correct Ans-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 Ans-
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 Ans-True
Which of the below is not a data preprocessing step?
data consolidation
data transformation
data separation
data reduction - Correct Ans-data seperation
Which of the below is a method to deal with filling out the missing values in data?
data cleaning
data reduction
data smoothing
data imputation - Correct Ans-data imputations
Which of the below statement(s) is/are correct?
A: An important data transformation subtask is to select the relevant data using domain
expert input, i.e., decide which sources and data to collect.
B: When merging two data source tables A and B, using the full outer join method
eliminates all rows from the resulting table that do not have corresponding rows in both
source tables A and B.
C: For numerical variables, normalizing the observed values between two values, such
as 0 and 1, allows to rescale the values and compare variables with different means
and/or standard deviations on a single scale.
D: Identifying and reducing noise in the data is a subtask of data reduction. - Correct
Ans-C
BSAN
BSAN 160 Exam Review 2025
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 Ans-False
Business Intelligence (BI) - Correct Ans-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 Ans-True
Descriptive Analytics - Correct Ans-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 Ans-
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 Ans-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 Ans-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 Ans-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 Ans-Pie Chart
BSAN
, BSAN
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 Ans-
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 Ans-True
T or F: Data reduction can be applied to rows (observations) and/or columns (variables)
in a given dataset - Correct Ans-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 Ans-
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 Ans-True
Which of the below is not a data preprocessing step?
data consolidation
data transformation
data separation
data reduction - Correct Ans-data seperation
Which of the below is a method to deal with filling out the missing values in data?
data cleaning
data reduction
data smoothing
data imputation - Correct Ans-data imputations
Which of the below statement(s) is/are correct?
A: An important data transformation subtask is to select the relevant data using domain
expert input, i.e., decide which sources and data to collect.
B: When merging two data source tables A and B, using the full outer join method
eliminates all rows from the resulting table that do not have corresponding rows in both
source tables A and B.
C: For numerical variables, normalizing the observed values between two values, such
as 0 and 1, allows to rescale the values and compare variables with different means
and/or standard deviations on a single scale.
D: Identifying and reducing noise in the data is a subtask of data reduction. - Correct
Ans-C
BSAN
