WGU D465 Data Applications Objective Assessment
And Pre Assessment Newest 2026/2027 Complete
Exam Questions And Answers with Rationales
TABLE OF CONTENTS
Section 1 — Data Fundamentals & Analytical Thinking
Section 2 — Spreadsheets & Data Preparation
Section 3 — SQL Fundamentals
Section 4 — SQL Queries, Joins & Aggregation
Section 5 — R & RStudio
Section 6 — Data Cleaning, Transformation & Analysis in R
Section 7 — Data Visualization & R Markdown
Section 8 — Integrated Data Applications & Decision-Making
SECTION 1 — DATA FUNDAMENTALS & ANALYTICAL THINKING
1. What is the primary purpose of data analysis?
A. To store as much data as possible
B. To identify meaningful patterns and relationships that support decisions
C. To eliminate the need for human judgment
D. To convert every dataset into a spreadsheet
Answer: B
Rationale: Data analysis turns raw information into useful insights. The
objective is to identify patterns, relationships, trends, and other findings that
can answer a defined business or analytical question.
,2. A company wants to determine why customer cancellations increased
during the previous quarter. What should the analyst do FIRST?
A. Build a dashboard
B. Delete incomplete records
C. Define the analytical question and required information
D. Calculate the average cancellation rate
Answer: C
Rationale: Analysis should begin with a clearly defined question. Without
knowing what must be answered, the analyst may collect or manipulate
irrelevant data.
3. Which is an example of structured data?
A. Customer comments in a text box
B. A video recording
C. A relational database table
D. An audio interview
Answer: C
Rationale: Structured data follows a defined schema, such as rows and
columns in a relational database. Text, video, and audio are generally less
structured.
4. Which characteristic means data is correct and free from errors?
A. Timeliness
B. Accuracy
C. Completeness
D. Uniqueness
,Answer: B
Rationale: Accuracy describes whether data correctly represents the real-
world value it is intended to represent.
5. A dataset contains the same customer three times because of duplicate
imports. Which data-quality problem exists?
A. Inconsistency
B. Duplication
C. Timeliness
D. Validity
Answer: B
Rationale: Duplicate records occur when the same entity is represented more
than once when only one record should exist.
6. Which question is most appropriate for descriptive analysis?
A. What will sales be next year?
B. Why will a customer leave?
C. What were total sales last quarter?
D. What intervention should management implement?
Answer: C
Rationale: Descriptive analysis summarizes what has already happened.
Forecasting is predictive, while recommending an intervention is prescriptive.
, 7. Predictive analytics primarily attempts to determine:
A. What happened
B. What is likely to happen
C. How data should be stored
D. Whether a spreadsheet contains formulas
Answer: B
Rationale: Predictive analytics uses historical and current information to
estimate likely future outcomes.
8. Which measure represents the middle value in an ordered dataset?
A. Mean
B. Mode
C. Median
D. Range
Answer: C
Rationale: The median is the middle observation after values are arranged in
order.
9. Which measure is most affected by an extremely large outlier?
A. Mean
B. Median
C. Mode
D. Quartile rank
Answer: A
And Pre Assessment Newest 2026/2027 Complete
Exam Questions And Answers with Rationales
TABLE OF CONTENTS
Section 1 — Data Fundamentals & Analytical Thinking
Section 2 — Spreadsheets & Data Preparation
Section 3 — SQL Fundamentals
Section 4 — SQL Queries, Joins & Aggregation
Section 5 — R & RStudio
Section 6 — Data Cleaning, Transformation & Analysis in R
Section 7 — Data Visualization & R Markdown
Section 8 — Integrated Data Applications & Decision-Making
SECTION 1 — DATA FUNDAMENTALS & ANALYTICAL THINKING
1. What is the primary purpose of data analysis?
A. To store as much data as possible
B. To identify meaningful patterns and relationships that support decisions
C. To eliminate the need for human judgment
D. To convert every dataset into a spreadsheet
Answer: B
Rationale: Data analysis turns raw information into useful insights. The
objective is to identify patterns, relationships, trends, and other findings that
can answer a defined business or analytical question.
,2. A company wants to determine why customer cancellations increased
during the previous quarter. What should the analyst do FIRST?
A. Build a dashboard
B. Delete incomplete records
C. Define the analytical question and required information
D. Calculate the average cancellation rate
Answer: C
Rationale: Analysis should begin with a clearly defined question. Without
knowing what must be answered, the analyst may collect or manipulate
irrelevant data.
3. Which is an example of structured data?
A. Customer comments in a text box
B. A video recording
C. A relational database table
D. An audio interview
Answer: C
Rationale: Structured data follows a defined schema, such as rows and
columns in a relational database. Text, video, and audio are generally less
structured.
4. Which characteristic means data is correct and free from errors?
A. Timeliness
B. Accuracy
C. Completeness
D. Uniqueness
,Answer: B
Rationale: Accuracy describes whether data correctly represents the real-
world value it is intended to represent.
5. A dataset contains the same customer three times because of duplicate
imports. Which data-quality problem exists?
A. Inconsistency
B. Duplication
C. Timeliness
D. Validity
Answer: B
Rationale: Duplicate records occur when the same entity is represented more
than once when only one record should exist.
6. Which question is most appropriate for descriptive analysis?
A. What will sales be next year?
B. Why will a customer leave?
C. What were total sales last quarter?
D. What intervention should management implement?
Answer: C
Rationale: Descriptive analysis summarizes what has already happened.
Forecasting is predictive, while recommending an intervention is prescriptive.
, 7. Predictive analytics primarily attempts to determine:
A. What happened
B. What is likely to happen
C. How data should be stored
D. Whether a spreadsheet contains formulas
Answer: B
Rationale: Predictive analytics uses historical and current information to
estimate likely future outcomes.
8. Which measure represents the middle value in an ordered dataset?
A. Mean
B. Mode
C. Median
D. Range
Answer: C
Rationale: The median is the middle observation after values are arranged in
order.
9. Which measure is most affected by an extremely large outlier?
A. Mean
B. Median
C. Mode
D. Quartile rank
Answer: A
