Page 1 of 80
WGU D204 EXAM OBJECTIVE ASSESSMENT EXAM
ACTUAL EXAM VERSION 1, 2 AND PRACTICE EXAM
ALL 400 QUESTIONS AND VERIFIED DETAILED
SOLUTIONS LATEST 2024-2025
WGU D204 EXAM 1
Which Activity does an analyst perform in the discovery phase of the data analytics life cycle?
a. Collecting Data
b. Cleaning Data
c. Identifying outliers
d. Identifying business nees - ANSWER-d. Identifying business needs
QUESTION: In which phase of the data analytics life cycle does an analyst build a histogram?
a. Data acquisition
b. Data exploration
c. Discovery
d. Predictive modeling - ANSWER-b. Data exploration
QUESTION: An analyst applies a statistical formula to obtain the average temperature for a city
over the last 50 years.Which phase of the data analytics life cycle is represented by this
activity?A.
1
,Page 2 of 80
A. Data acquisition
B. Exploratory data analysis
C. Predictive modeling
D. Data reporting - ANSWER-B. Exploratory data analysis
QUESTION: An analyst has been tasked with defining data columns that could contain null
values. Which activity of the data acquisition phase is represented?
a. Collecting data
b. Disqualifying data sources
c. Detecting missing values
d. Transforming improperly formatted text. - ANSWER-c. Detecting missing values
QUESTION: Which activity in the data analytics life cycle occurs during the data acquisition
phase and requires the most time and effort from the data analyst?
a. Selecting the data sources
b. Importing data into a database
c. Cleaning the data
d. Defining goals - ANSWER-c. Cleaning the data
QUESTION: What might be developed by data analysts when acquiring data from a data
warehouse?
a. The procedures for extracting files from the data warehouse.
2
,Page 3 of 80
b. The procedures for updating tables in the data warehouse.
c. The relational structure of tables.
d. The SQL queries of data within the tables - ANSWER-d. The SQL queries of data within the
tables.
QUESTION: What can be identified using a box plot?
a. Frequency
b. Correlation
c. Interquartile range
d. Mean - ANSWER-c. Interquartile range
QUESTION: What will be a consequence of poor attention to detail during the data exploration
phase?
a. Not enough variables will be considered in the analysis.
b. The outcome of the analysis will be misaligned to business needs.
c. The analyst will lack insight into the structure of the data set.
d. The model will be built using the wrong data set. - ANSWER-c. The analyst will lack insight
into the structure of the data set.
QUESTION: Which aspect of data exploration occurs when an analyst writes code to compile a
bar graph of dog food sales per month?
a. Performance of a correlation analysis
3
, Page 4 of 80
b. Analysis of data anomalies
c. Verification through visualization
d. Determination of variabilities - ANSWER-c. Verification through visualization
QUESTION: An oil company uses robots and sensors to detect how pipeline corrosion changes
over time. The collected data is then used in a predictive model that estimates when a pipe
should be replaced. How does the predictive model serve this oil company?
a. To minimize interruptions from maintenance shutdowns
b. To minimize the need for workforce safety training
c. To improve compliance with pipeline construction standards
d. To improve compliance with pipeline disposal standards - ANSWER-a. To minimize
interruptions from maintenance shutdowns
QUESTION: During which phase in the data analytics life cycle would a churn analysis be
performed?
a. Data cleaning
b. Data acquisition
c. Predictive analysis
d. Representation and reporting - ANSWER-c. Predictive analysis
QUESTION: Which mistake is commonly made during the predictive analytics phase?
a. The data are separated into different sets
4
WGU D204 EXAM OBJECTIVE ASSESSMENT EXAM
ACTUAL EXAM VERSION 1, 2 AND PRACTICE EXAM
ALL 400 QUESTIONS AND VERIFIED DETAILED
SOLUTIONS LATEST 2024-2025
WGU D204 EXAM 1
Which Activity does an analyst perform in the discovery phase of the data analytics life cycle?
a. Collecting Data
b. Cleaning Data
c. Identifying outliers
d. Identifying business nees - ANSWER-d. Identifying business needs
QUESTION: In which phase of the data analytics life cycle does an analyst build a histogram?
a. Data acquisition
b. Data exploration
c. Discovery
d. Predictive modeling - ANSWER-b. Data exploration
QUESTION: An analyst applies a statistical formula to obtain the average temperature for a city
over the last 50 years.Which phase of the data analytics life cycle is represented by this
activity?A.
1
,Page 2 of 80
A. Data acquisition
B. Exploratory data analysis
C. Predictive modeling
D. Data reporting - ANSWER-B. Exploratory data analysis
QUESTION: An analyst has been tasked with defining data columns that could contain null
values. Which activity of the data acquisition phase is represented?
a. Collecting data
b. Disqualifying data sources
c. Detecting missing values
d. Transforming improperly formatted text. - ANSWER-c. Detecting missing values
QUESTION: Which activity in the data analytics life cycle occurs during the data acquisition
phase and requires the most time and effort from the data analyst?
a. Selecting the data sources
b. Importing data into a database
c. Cleaning the data
d. Defining goals - ANSWER-c. Cleaning the data
QUESTION: What might be developed by data analysts when acquiring data from a data
warehouse?
a. The procedures for extracting files from the data warehouse.
2
,Page 3 of 80
b. The procedures for updating tables in the data warehouse.
c. The relational structure of tables.
d. The SQL queries of data within the tables - ANSWER-d. The SQL queries of data within the
tables.
QUESTION: What can be identified using a box plot?
a. Frequency
b. Correlation
c. Interquartile range
d. Mean - ANSWER-c. Interquartile range
QUESTION: What will be a consequence of poor attention to detail during the data exploration
phase?
a. Not enough variables will be considered in the analysis.
b. The outcome of the analysis will be misaligned to business needs.
c. The analyst will lack insight into the structure of the data set.
d. The model will be built using the wrong data set. - ANSWER-c. The analyst will lack insight
into the structure of the data set.
QUESTION: Which aspect of data exploration occurs when an analyst writes code to compile a
bar graph of dog food sales per month?
a. Performance of a correlation analysis
3
, Page 4 of 80
b. Analysis of data anomalies
c. Verification through visualization
d. Determination of variabilities - ANSWER-c. Verification through visualization
QUESTION: An oil company uses robots and sensors to detect how pipeline corrosion changes
over time. The collected data is then used in a predictive model that estimates when a pipe
should be replaced. How does the predictive model serve this oil company?
a. To minimize interruptions from maintenance shutdowns
b. To minimize the need for workforce safety training
c. To improve compliance with pipeline construction standards
d. To improve compliance with pipeline disposal standards - ANSWER-a. To minimize
interruptions from maintenance shutdowns
QUESTION: During which phase in the data analytics life cycle would a churn analysis be
performed?
a. Data cleaning
b. Data acquisition
c. Predictive analysis
d. Representation and reporting - ANSWER-c. Predictive analysis
QUESTION: Which mistake is commonly made during the predictive analytics phase?
a. The data are separated into different sets
4
