WGU D465 DATA APPLICATIONS OA EXAM ACTUAL
QUESTIONS AND CORRECT ANSWERS
Which task is an analyst performing in a spreadsheet when they isolate data
that meets specific, exclusive criteria?
Filtering Data
Which command should an analyst use to identify which table to access in a
database using a Structured Query Language (SQL)?
FROM
How can an analyst sort all areas of Microsoft Excel and Google Sheets
spreadsheets to organize data for analysis?
"sort sheet"
Which method can an analyst use to categorize data based on a specific metric
in Microsoft Excel and Google Sheets spreadsheets for data analysis?
Write a sort function
An analyst needs to manipulate and categorize data using a spreadsheet and
Structured Query Language (SQL).How can they format and adjust data for
analysis?
Sort and Filter data
,How does an analyst reorganize the layout of data in Microsoft Excel or Google
Sheets spreadsheets based on product type while keeping all rows visible?
SORT function
How does a pivot table custom list sort by default for analysis?
In ascending order first
An analyst is working with data in a Google Sheet spreadsheet that lists
temperatures in Fahrenheit but needs the data to be in Celsius.How can the
analyst change the unit of measurement?
Use the CONVERT function
An analyst is working with a Microsoft Excel spreadsheet that will later be
shared with a project team.Why would the analyst use the validation function
on this sheet?
To control the type of data entered
An analyst wants to format all data in a column to YYYY-MM-DD format to be
represented by dates and times with values ranging from 00:00:00 to 11:59:59
using Structured Query Language (SQL). The analyst uses the DATETIME
command. What does this command do to the data?
Data will be converted to a datetime value.
Why does an analyst use the LEN function in Microsoft Excel and Google Sheets
spreadsheets?
, To determine the length of a string
Why does an analyst use the CONCAT_WS function in Structured Query
Language (SQL)?
To add two or more strings together with a separator
Which programming language can handle trillions of rows of data and is now a
standard language for working with database programs?
Structured Query Language (SQL)
An analyst is working on a project with a lot of milestones to track and wants to
create a spreadsheet that everyone can use to track their individual
progress.How could the analyst sort and filter progress milestones?
Create a data validation menu in cells with predetermined options
An analyst working with data in two different Google Sheets needs information
from both spreadsheets to connect together in a matching column on a single
sheet.Which function should the analyst use?
VLOOKUP
An analyst working to aggregate data in databases uses a Structured Query
Language (SQL) command that returns all matching records in two tables and
the key values in each.Which command has the analyst used?
INNER JOIN
QUESTIONS AND CORRECT ANSWERS
Which task is an analyst performing in a spreadsheet when they isolate data
that meets specific, exclusive criteria?
Filtering Data
Which command should an analyst use to identify which table to access in a
database using a Structured Query Language (SQL)?
FROM
How can an analyst sort all areas of Microsoft Excel and Google Sheets
spreadsheets to organize data for analysis?
"sort sheet"
Which method can an analyst use to categorize data based on a specific metric
in Microsoft Excel and Google Sheets spreadsheets for data analysis?
Write a sort function
An analyst needs to manipulate and categorize data using a spreadsheet and
Structured Query Language (SQL).How can they format and adjust data for
analysis?
Sort and Filter data
,How does an analyst reorganize the layout of data in Microsoft Excel or Google
Sheets spreadsheets based on product type while keeping all rows visible?
SORT function
How does a pivot table custom list sort by default for analysis?
In ascending order first
An analyst is working with data in a Google Sheet spreadsheet that lists
temperatures in Fahrenheit but needs the data to be in Celsius.How can the
analyst change the unit of measurement?
Use the CONVERT function
An analyst is working with a Microsoft Excel spreadsheet that will later be
shared with a project team.Why would the analyst use the validation function
on this sheet?
To control the type of data entered
An analyst wants to format all data in a column to YYYY-MM-DD format to be
represented by dates and times with values ranging from 00:00:00 to 11:59:59
using Structured Query Language (SQL). The analyst uses the DATETIME
command. What does this command do to the data?
Data will be converted to a datetime value.
Why does an analyst use the LEN function in Microsoft Excel and Google Sheets
spreadsheets?
, To determine the length of a string
Why does an analyst use the CONCAT_WS function in Structured Query
Language (SQL)?
To add two or more strings together with a separator
Which programming language can handle trillions of rows of data and is now a
standard language for working with database programs?
Structured Query Language (SQL)
An analyst is working on a project with a lot of milestones to track and wants to
create a spreadsheet that everyone can use to track their individual
progress.How could the analyst sort and filter progress milestones?
Create a data validation menu in cells with predetermined options
An analyst working with data in two different Google Sheets needs information
from both spreadsheets to connect together in a matching column on a single
sheet.Which function should the analyst use?
VLOOKUP
An analyst working to aggregate data in databases uses a Structured Query
Language (SQL) command that returns all matching records in two tables and
the key values in each.Which command has the analyst used?
INNER JOIN
