WGU D370 – Data Analytics Final Prep
Exam (Latest Update 2026/2027)
Questions and Verified Answers | 100%
Correct | Grade A.
1. What is the primary goal of data analytics?
A. To replace human decision-making entirely
B. To store unlimited amounts of data
C. To analyze data and generate actionable insights
D. To eliminate all business risks
Rationale: Data analytics involves examining data to identify patterns,
trends, and relationships that support informed decision-making. While
analytics can reduce uncertainty, it cannot eliminate all business risks.
2. Which type of analytics answers the question, "What happened?"
A. Predictive analytics
B. Descriptive analytics
C. Prescriptive analytics
D. Diagnostic analytics
,Rationale: Descriptive analytics summarizes historical data using
reports, dashboards, and visualizations. It focuses on understanding
past events rather than predicting future outcomes.
3. Which type of analytics attempts to determine why an event
occurred?
A. Predictive analytics
B. Prescriptive analytics
C. Diagnostic analytics
D. Cognitive analytics
Rationale: Diagnostic analytics explores relationships, root causes, and
contributing factors that explain historical outcomes.
4. Predictive analytics primarily relies on:
A. Manual observations
B. Business intuition alone
C. Historical data and statistical models
D. Paper-based reports
Rationale: Predictive analytics uses historical data combined with
statistical techniques and machine learning algorithms to forecast
future events or behaviors.
5. Which analytics type recommends actions based on predicted
outcomes?
,A. Descriptive analytics
B. Diagnostic analytics
C. Predictive analytics
D. Prescriptive analytics
Rationale: Prescriptive analytics evaluates multiple possible actions and
recommends optimal decisions using optimization models and
simulations.
6. Which of the following best defines structured data?
A. Audio recordings
B. Images stored in folders
C. Data organized into rows and columns
D. Social media comments
Rationale: Structured data follows a predefined format, making it easy
to store, query, and analyze using relational databases.
7. Which is an example of unstructured data?
A. Excel spreadsheet
B. SQL database table
C. Inventory database
D. Customer email messages
Rationale: Emails contain free-form text that lacks a predefined
structure, making them examples of unstructured data.
, 8. What does ETL stand for?
A. Evaluate, Transfer, Load
B. Extract, Test, Link
C. Extract, Transform, Load
D. Export, Translate, Locate
Rationale: ETL is the process of extracting data from source systems,
transforming it into a usable format, and loading it into a destination
such as a data warehouse.
9. Why is data cleaning important?
A. It increases storage costs.
B. It guarantees perfect predictions.
C. It improves data quality before analysis.
D. It removes all historical information.
Rationale: Data cleaning identifies and corrects inaccuracies, duplicates,
inconsistencies, and missing values, leading to more reliable analytical
results.
10. Which measure represents the average value of a dataset?
A. Median
B. Mode
C. Mean
D. Range
Exam (Latest Update 2026/2027)
Questions and Verified Answers | 100%
Correct | Grade A.
1. What is the primary goal of data analytics?
A. To replace human decision-making entirely
B. To store unlimited amounts of data
C. To analyze data and generate actionable insights
D. To eliminate all business risks
Rationale: Data analytics involves examining data to identify patterns,
trends, and relationships that support informed decision-making. While
analytics can reduce uncertainty, it cannot eliminate all business risks.
2. Which type of analytics answers the question, "What happened?"
A. Predictive analytics
B. Descriptive analytics
C. Prescriptive analytics
D. Diagnostic analytics
,Rationale: Descriptive analytics summarizes historical data using
reports, dashboards, and visualizations. It focuses on understanding
past events rather than predicting future outcomes.
3. Which type of analytics attempts to determine why an event
occurred?
A. Predictive analytics
B. Prescriptive analytics
C. Diagnostic analytics
D. Cognitive analytics
Rationale: Diagnostic analytics explores relationships, root causes, and
contributing factors that explain historical outcomes.
4. Predictive analytics primarily relies on:
A. Manual observations
B. Business intuition alone
C. Historical data and statistical models
D. Paper-based reports
Rationale: Predictive analytics uses historical data combined with
statistical techniques and machine learning algorithms to forecast
future events or behaviors.
5. Which analytics type recommends actions based on predicted
outcomes?
,A. Descriptive analytics
B. Diagnostic analytics
C. Predictive analytics
D. Prescriptive analytics
Rationale: Prescriptive analytics evaluates multiple possible actions and
recommends optimal decisions using optimization models and
simulations.
6. Which of the following best defines structured data?
A. Audio recordings
B. Images stored in folders
C. Data organized into rows and columns
D. Social media comments
Rationale: Structured data follows a predefined format, making it easy
to store, query, and analyze using relational databases.
7. Which is an example of unstructured data?
A. Excel spreadsheet
B. SQL database table
C. Inventory database
D. Customer email messages
Rationale: Emails contain free-form text that lacks a predefined
structure, making them examples of unstructured data.
, 8. What does ETL stand for?
A. Evaluate, Transfer, Load
B. Extract, Test, Link
C. Extract, Transform, Load
D. Export, Translate, Locate
Rationale: ETL is the process of extracting data from source systems,
transforming it into a usable format, and loading it into a destination
such as a data warehouse.
9. Why is data cleaning important?
A. It increases storage costs.
B. It guarantees perfect predictions.
C. It improves data quality before analysis.
D. It removes all historical information.
Rationale: Data cleaning identifies and corrects inaccuracies, duplicates,
inconsistencies, and missing values, leading to more reliable analytical
results.
10. Which measure represents the average value of a dataset?
A. Median
B. Mode
C. Mean
D. Range
