WPC 300 FINAL EXAM Business Problem Solving
& Analytics 150 Questions with Verified Solutions
and Rationales
Exam Structure:
Total Questions: 150
Format: Multiple Choice & Multiple Select
Time Limit: 3 hours
Passing Score: 70%
Domains: Analytics Foundations, Statistics, Problem-Solving Frameworks,
ETL & Data Management, Machine Learning, Decision-Making Biases
Section 1: Analytics Foundations & Types (Questions 1-25)
1. What is the formal definition of "analytics" in a business context?
A) The process of collecting raw data without any specific purpose
B) The process of developing actionable decisions or recommendations
based on insights generated from historical data
C) The process of creating visualizations without statistical analysis
D) The process of storing data in databases for future use
Answer: B
Rationale: Analytics is formally defined as the process of developing
actionable decisions or recommendations for actions based upon insights
generated from historical data. It combines statistics, management science,
and technology to drive decision-making .
2. A marketing analyst creates a dashboard showing last quarter's sales by
region. What type of analytics is this?
A) Predictive analytics
B) Prescriptive analytics
,C) Descriptive analytics
D) Diagnostic analytics
Answer: C
Rationale: Descriptive analytics answers "What happened?" by summarizing
historical data. Dashboards, reports, and visualizations of past performance
are descriptive. Predictive looks forward, and prescriptive recommends
actions .
3. A data scientist builds a model to forecast next month's customer demand.
What type of analytics is this?
A) Descriptive analytics
B) Predictive analytics
C) Prescriptive analytics
D) Explanatory analytics
Answer: B
Rationale: Predictive analytics uses historical data to forecast future
outcomes. It answers "What will happen?" Forecasting demand, predicting
churn, and estimating risk are predictive applications .
4. A logistics company uses an optimization model to determine the most
efficient delivery routes. What type of analytics is this?
A) Descriptive analytics
B) Predictive analytics
C) Prescriptive analytics
D) Diagnostic analytics
Answer: C
Rationale: Prescriptive analytics recommends specific actions to optimize
outcomes. It answers "What should we do?" using optimization models,
simulations, and decision rules .
5. A manager reviews a report explaining why sales decreased last month.
This is an example of:
A) Descriptive analytics
B) Predictive analytics
,C) Prescriptive analytics
D) Diagnostic (explanatory) analytics
Answer: D
Rationale: Diagnostic or explanatory analytics answers "Why did it happen?"
It identifies root causes and relationships to explain past outcomes, often
using techniques like drill-down analysis or correlation .
6. Which statement correctly differentiates analytics from heuristics?
A) Analytics relies on intuition and experience; heuristics relies on data
B) Analytics is structured and data-driven; heuristics is experience-based and
rule-of-thumb
C) Analytics is faster than heuristics
D) Analytics is only used for large datasets
Answer: B
Rationale: Analytics uses structured, data-driven methods to reach
conclusions, while heuristics are experience-based mental shortcuts or "rules
of thumb." Both have value, but analytics is more systematic and evidence-
based .
7. What is the first step in the agile analytics process?
A) Perform data discovery
B) Perform business discovery
C) Score and deploy the model
D) Model the data
Answer: B
Rationale: In an agile analytics approach, the first step is business
discovery—understanding the business problem, objectives, and stakeholder
needs before any data work begins. This ensures alignment with business
goals .
8. The agile analytics process includes all of the following steps EXCEPT:
A) Perform business discovery
B) Perform data discovery
, C) Create a detailed 12-month project plan
D) Score and deploy
Answer: C
Rationale: Agile analytics emphasizes iterative, short-cycle work rather than
detailed long-term plans. Steps include business discovery, data discovery,
data preparation, modeling, evaluation, and deployment .
9. Which type of analytics is most closely associated with the question "What
should we do to achieve the best outcome?"
A) Descriptive
B) Predictive
C) Prescriptive
D) Diagnostic
Answer: C
Rationale: Prescriptive analytics directly addresses action recommendations
to optimize outcomes. It goes beyond prediction to suggest specific
decisions .
10. Which type of analytics answers the question "What happened?"
A) Prescriptive
B) Predictive
C) Descriptive
D) Diagnostic
Answer: C
Rationale: Descriptive analytics summarizes historical data to answer "What
happened?" Dashboards and standard reports are common descriptive tools .
11. A bank builds a model to predict which loan applicants are likely to
default. This is:
A) Descriptive analytics
B) Predictive analytics
C) Prescriptive analytics
D) Diagnostic analytics
& Analytics 150 Questions with Verified Solutions
and Rationales
Exam Structure:
Total Questions: 150
Format: Multiple Choice & Multiple Select
Time Limit: 3 hours
Passing Score: 70%
Domains: Analytics Foundations, Statistics, Problem-Solving Frameworks,
ETL & Data Management, Machine Learning, Decision-Making Biases
Section 1: Analytics Foundations & Types (Questions 1-25)
1. What is the formal definition of "analytics" in a business context?
A) The process of collecting raw data without any specific purpose
B) The process of developing actionable decisions or recommendations
based on insights generated from historical data
C) The process of creating visualizations without statistical analysis
D) The process of storing data in databases for future use
Answer: B
Rationale: Analytics is formally defined as the process of developing
actionable decisions or recommendations for actions based upon insights
generated from historical data. It combines statistics, management science,
and technology to drive decision-making .
2. A marketing analyst creates a dashboard showing last quarter's sales by
region. What type of analytics is this?
A) Predictive analytics
B) Prescriptive analytics
,C) Descriptive analytics
D) Diagnostic analytics
Answer: C
Rationale: Descriptive analytics answers "What happened?" by summarizing
historical data. Dashboards, reports, and visualizations of past performance
are descriptive. Predictive looks forward, and prescriptive recommends
actions .
3. A data scientist builds a model to forecast next month's customer demand.
What type of analytics is this?
A) Descriptive analytics
B) Predictive analytics
C) Prescriptive analytics
D) Explanatory analytics
Answer: B
Rationale: Predictive analytics uses historical data to forecast future
outcomes. It answers "What will happen?" Forecasting demand, predicting
churn, and estimating risk are predictive applications .
4. A logistics company uses an optimization model to determine the most
efficient delivery routes. What type of analytics is this?
A) Descriptive analytics
B) Predictive analytics
C) Prescriptive analytics
D) Diagnostic analytics
Answer: C
Rationale: Prescriptive analytics recommends specific actions to optimize
outcomes. It answers "What should we do?" using optimization models,
simulations, and decision rules .
5. A manager reviews a report explaining why sales decreased last month.
This is an example of:
A) Descriptive analytics
B) Predictive analytics
,C) Prescriptive analytics
D) Diagnostic (explanatory) analytics
Answer: D
Rationale: Diagnostic or explanatory analytics answers "Why did it happen?"
It identifies root causes and relationships to explain past outcomes, often
using techniques like drill-down analysis or correlation .
6. Which statement correctly differentiates analytics from heuristics?
A) Analytics relies on intuition and experience; heuristics relies on data
B) Analytics is structured and data-driven; heuristics is experience-based and
rule-of-thumb
C) Analytics is faster than heuristics
D) Analytics is only used for large datasets
Answer: B
Rationale: Analytics uses structured, data-driven methods to reach
conclusions, while heuristics are experience-based mental shortcuts or "rules
of thumb." Both have value, but analytics is more systematic and evidence-
based .
7. What is the first step in the agile analytics process?
A) Perform data discovery
B) Perform business discovery
C) Score and deploy the model
D) Model the data
Answer: B
Rationale: In an agile analytics approach, the first step is business
discovery—understanding the business problem, objectives, and stakeholder
needs before any data work begins. This ensures alignment with business
goals .
8. The agile analytics process includes all of the following steps EXCEPT:
A) Perform business discovery
B) Perform data discovery
, C) Create a detailed 12-month project plan
D) Score and deploy
Answer: C
Rationale: Agile analytics emphasizes iterative, short-cycle work rather than
detailed long-term plans. Steps include business discovery, data discovery,
data preparation, modeling, evaluation, and deployment .
9. Which type of analytics is most closely associated with the question "What
should we do to achieve the best outcome?"
A) Descriptive
B) Predictive
C) Prescriptive
D) Diagnostic
Answer: C
Rationale: Prescriptive analytics directly addresses action recommendations
to optimize outcomes. It goes beyond prediction to suggest specific
decisions .
10. Which type of analytics answers the question "What happened?"
A) Prescriptive
B) Predictive
C) Descriptive
D) Diagnostic
Answer: C
Rationale: Descriptive analytics summarizes historical data to answer "What
happened?" Dashboards and standard reports are common descriptive tools .
11. A bank builds a model to predict which loan applicants are likely to
default. This is:
A) Descriptive analytics
B) Predictive analytics
C) Prescriptive analytics
D) Diagnostic analytics
