WGU D465 - Data Applications Objective Assessment | OA V1 and V2 |
Questions and Answers | 2026 Update | 100% Correct.
Correct 126
Incorrect
Questions and answers
1 of 126
Definition
Subset rows based on specific conditions in R.
Give this one a try later!
tibbles vs. data frames
dplyr filter() function
fill in the blank: the ____ of a pivot table organize and group the selected data
horizontally.
columns
rows
filters
values
, fill in the blank: a data analyst uses ____ to copy data from one table into a
temporary table without adding the new table to the database.
temp
copy to
with
select into
Don't know?
2 of 126
Term
You prepare a project tracker spreadsheet. Next to each project is the
name of the team member responsible. What spreadsheet tool will
create a drop-down list with team member names to save you time
when assigning the projects?
Data validation
Conditional formatting
Pop-up menus
Find
Give this one a try later!
SELECT INTO Calculated field
temporary table Data validation
, Don't know?
3 of 126
Term
Why might a data professional add a CREATE TABLE statement to a
temporary table?
Include metadata about the data in the table
Automate calculations in the table
Give multiple people access to the table
Create a second table within the temporary table
Give this one a try later!
HAVING Give multiple people access to
COUNT(order_items.product_id) > 100 the table
trends and relationships The values in cells B2 through B31
Don't know?
4 of 126
Term
, A junior data analyst performs several calculations on a dataset. What
phase of analysis is the analyst in?
Transform data
Format and adjust data
Organize data
Get input from others
Give this one a try later!
Data validation Innermost
Transform data SELECT INTO
Don't know?
5 of 126
Term
Fill in the blank: The goal of analysis is to identify ____ within data in
order to accurately answer questions and solve problems.
opportunities and risks
trends and relationships
all possible insights
value and meaning
Give this one a try later!
Questions and Answers | 2026 Update | 100% Correct.
Correct 126
Incorrect
Questions and answers
1 of 126
Definition
Subset rows based on specific conditions in R.
Give this one a try later!
tibbles vs. data frames
dplyr filter() function
fill in the blank: the ____ of a pivot table organize and group the selected data
horizontally.
columns
rows
filters
values
, fill in the blank: a data analyst uses ____ to copy data from one table into a
temporary table without adding the new table to the database.
temp
copy to
with
select into
Don't know?
2 of 126
Term
You prepare a project tracker spreadsheet. Next to each project is the
name of the team member responsible. What spreadsheet tool will
create a drop-down list with team member names to save you time
when assigning the projects?
Data validation
Conditional formatting
Pop-up menus
Find
Give this one a try later!
SELECT INTO Calculated field
temporary table Data validation
, Don't know?
3 of 126
Term
Why might a data professional add a CREATE TABLE statement to a
temporary table?
Include metadata about the data in the table
Automate calculations in the table
Give multiple people access to the table
Create a second table within the temporary table
Give this one a try later!
HAVING Give multiple people access to
COUNT(order_items.product_id) > 100 the table
trends and relationships The values in cells B2 through B31
Don't know?
4 of 126
Term
, A junior data analyst performs several calculations on a dataset. What
phase of analysis is the analyst in?
Transform data
Format and adjust data
Organize data
Get input from others
Give this one a try later!
Data validation Innermost
Transform data SELECT INTO
Don't know?
5 of 126
Term
Fill in the blank: The goal of analysis is to identify ____ within data in
order to accurately answer questions and solve problems.
opportunities and risks
trends and relationships
all possible insights
value and meaning
Give this one a try later!
