Page 1 of 62
1
WGU D204 EXAM LATEST 2024-2025 ALL 2 LATEST VERSIONS
AND STUDY GUIDE COMPLETE 350 QUESTIONS AND CORRECT
DETAILED ANSWERS ALREADY GRADED A+
WGU D204 EXAM A
Q: 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?
- To minimize interruptions from maintenance shutdowns
- To minimize the need for workforce safety training
- To improve compliance with pipeline construction standards
- To improve compliance with pipeline disposal standards - ANSWER-a. To minimize
interruptions from maintenance shutdowns
Q: During which phase in the data analytics life cycle would a churn analysis be performed?
- Data cleaning
- Data acquisition
- Predictive analysis
- Representation and reporting - ANSWER-c. Predictive analysis
Q: Which mistake is commonly made during the predictive analytics phase?
- The data are separated into different sets
- The variables are separated into response and independent variables
- The data are prepared before the model is developed
- The model is developed before the research question is known - ANSWER-d. The model is
- / 4
developed before the research question is known
Page 2 of 62
2 Q: Why might a data analyst resample a data set with replacement data in a data mining project?
- Misidentification of causation due to correlation
- Wrong variables chosen for analyzation
- Too little data for training and testing data sets
- skewed data resulting from outliers - ANSWER-c. Too little data for training and testing data
sets
Q: A data analyst has identified combinations of sales transactions that frequently occur together in data over the past 5 years.Which phase of the data analytics life cycle is represented by this analysis?
- Data acquisition
- Representation and reporting
- Data mining
- Predictive modeling - ANSWER-C. Data mining
Q: An analyst realizes that the data set has been reduced significantly, resulting in sample sizes that are too small.In which phase of the data analytics life cycle did this likely occur?
- Data exploration
- Data modeling
- Data mining
- Data discovery - ANSWER-C. Data mining
Which Activity does an analyst perform in the discovery phase of the data analytics life cycle?
- Collecting Data
- Cleaning Data 2 / 4
Page 3 of 62
3
- Identifying outliers
- Identifying business nees - ANSWER-d. Identifying business needs
Q: In which phase of the data analytics life cycle does an analyst build a histogram?
- Data acquisition
- Data exploration
- Discovery
- Predictive modeling - ANSWER-b. Data exploration
Q: 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.
- Data acquisition
- Exploratory data analysis
- Predictive modeling
- Data reporting - ANSWER-B. Exploratory data analysis
Q: An analyst has been tasked with defining data columns that could contain null values. Which activity of the data acquisition phase is represented?
- Collecting data
- Disqualifying data sources
- Detecting missing values
- Transforming improperly formatted text. - ANSWER-c. Detecting missing values
Q: 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?
- Selecting the data sources 3 / 4
Page 4 of 62
4
- Importing data into a database
- Cleaning the data
- Defining goals - ANSWER-c. Cleaning the data
Q: What might be developed by data analysts when acquiring data from a data warehouse?
- The procedures for extracting files from the data warehouse.
- The procedures for updating tables in the data warehouse.
- The relational structure of tables.
- The SQL queries of data within the tables - ANSWER-d. The SQL queries of data within the
tables.
Q: What can be identified using a box plot?
- Frequency
- Correlation
- Interquartile range
- Mean - ANSWER-c. Interquartile range
Q: What will be a consequence of poor attention to detail during the data exploration phase?
- Not enough variables will be considered in the analysis.
- The outcome of the analysis will be misaligned to business needs.
- The analyst will lack insight into the structure of the data set.
- The model will be built using the wrong data set. - ANSWER-c. The analyst will lack insight
into the structure of the data set.
Q: Which aspect of data exploration occurs when an analyst writes code to compile a bar graph of dog food sales per month?
- Performance of a correlation analysis
- / 4