WPC 300 FINAL EXAM SCRIPT PREMIUM
QUESTIONS AND SOLUTIONS GRADED A+
●● In an ETL process, data is loaded into a final target database such as
Answer: Data Warehouse
●● 4 types of Data Analytical method
Answer: Descriptive, Explanatory, Predictive, and Prescriptive
●● Example of secondary data
Answer: Firm's proprietary data
●● What data analysis models use optimization techniques?
Answer: Prescriptive analytics
●● Predictive analytics may be applied to ____, which is a set of
techniques that use descriptive data and forecasts to identify the
decisions most likely to result in the best performance.
Answer: Prescriptive analytics
●● Target is examining their online sales data during the pandemic to
understand what happened. Which kind of analytical technique are they
using?
,Answer: Descriptive
●● Costco wants to know how to stock their warehouses for a future
pandemic and are using current sales data to help them project the needs.
Which kind of analytical technique are they using
Answer: Predictive analytics
●● Your professor is considering purchasing a self-driving car that can
figure out the best route and the optimum safe way to drive there without
human intervention. What kind of analytics is the car using to do this?
Answer: Prescriptive analytics
●● Questions answered using data in order to reach an evidence-based
conclusion?
Answer: 1. how many students will enroll for an online class in the
spring?
2. what is the purchase patterns of our customers?
3. who will win the NBA championship?
●● In order for a chart to have graphical integrity, the lie factor must be:
Answer: close to 1
●● Deleting the grid lines in a chart
Answer: Increases the data-ink ratio
, ●● In order for a chart to minimize graphical complexity, the data-ink
ratio must be:
Answer: close to 1
●● Which of the following statement about charts is true?
Answer: Data ink can sometimes help tell a richer story
●● Which are useful principles for data visualization?
Answer: The graph suggests a possible true effect
●● Which of the following violates the principle of data visualization?
Answer: The data-ink ratio should be high than 1
●● Which of the following statements is a reason not to use a table for
data visualization?
Answer: Tables cannot easily show trends
●● What best describes the nature of a rose diagram?
Answer: Plots data using a circular historical plot
●● Statement about charts
QUESTIONS AND SOLUTIONS GRADED A+
●● In an ETL process, data is loaded into a final target database such as
Answer: Data Warehouse
●● 4 types of Data Analytical method
Answer: Descriptive, Explanatory, Predictive, and Prescriptive
●● Example of secondary data
Answer: Firm's proprietary data
●● What data analysis models use optimization techniques?
Answer: Prescriptive analytics
●● Predictive analytics may be applied to ____, which is a set of
techniques that use descriptive data and forecasts to identify the
decisions most likely to result in the best performance.
Answer: Prescriptive analytics
●● Target is examining their online sales data during the pandemic to
understand what happened. Which kind of analytical technique are they
using?
,Answer: Descriptive
●● Costco wants to know how to stock their warehouses for a future
pandemic and are using current sales data to help them project the needs.
Which kind of analytical technique are they using
Answer: Predictive analytics
●● Your professor is considering purchasing a self-driving car that can
figure out the best route and the optimum safe way to drive there without
human intervention. What kind of analytics is the car using to do this?
Answer: Prescriptive analytics
●● Questions answered using data in order to reach an evidence-based
conclusion?
Answer: 1. how many students will enroll for an online class in the
spring?
2. what is the purchase patterns of our customers?
3. who will win the NBA championship?
●● In order for a chart to have graphical integrity, the lie factor must be:
Answer: close to 1
●● Deleting the grid lines in a chart
Answer: Increases the data-ink ratio
, ●● In order for a chart to minimize graphical complexity, the data-ink
ratio must be:
Answer: close to 1
●● Which of the following statement about charts is true?
Answer: Data ink can sometimes help tell a richer story
●● Which are useful principles for data visualization?
Answer: The graph suggests a possible true effect
●● Which of the following violates the principle of data visualization?
Answer: The data-ink ratio should be high than 1
●● Which of the following statements is a reason not to use a table for
data visualization?
Answer: Tables cannot easily show trends
●● What best describes the nature of a rose diagram?
Answer: Plots data using a circular historical plot
●● Statement about charts
