WGU D465 Exam Questions and Answers – practice questions with answers

WGU D465 EXAM QUESTIONS AND ANSWERS


1. Which task is an analyst performing in a spreadsheet when they
isolate data that meets specific, exclusive criteria?: Filtering Data
2. Which command should an analyst use to identify which table to
access in a database using a Structured Query Language (SQL)?:
FROM
3. How can an analyst sort all areas of Microsoft Excel and Google
Sheets spreadsheets to organize data for analysis?: "sort sheet"
4. Which method can an analyst use to categorize data based on a
specific met-ric in Microsoft Excel and Google Sheets spreadsheets for
data analysis?: Write a sort function
5. 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
6. 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
7. How does a pivot table custom list sort by default for analysis?: In


,ascending order first
8. 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
9. 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
10. 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.
11. Why does an analyst use the LEN function in Microsoft Excel and
Google Sheets spreadsheets?: To determine the length of a string
12. Why does an analyst use the CONCAT_WS function in Structured
Query Language (SQL)?: To add two or more strings together with a
separator






, 13. 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)
14. 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
15. An analyst working with data in two different Google Sheets needs
infor-mation from both spreadsheets to connect together in a
matching column on a single sheet.Which function should the analyst
use?: VLOOKUP
16. 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
17. An analyst working to aggregate data in databases wants to
create a temporary name for a table with a complex name to make
Structured Query Language (SQL) queries simpler. Which command
should the analyst use?: AS
18. An analyst working to aggregate data in databases uses a Structured
Query Language (SQL) command to create a temporary name for a
table and re-ceives an ERROR message when the command is
used.Which command does the analyst use to create a temporary
name for a table?: FROM
19. An analyst working in a spreadsheet needs to determine the total
quantity of numerical values within a specific range that are
unique.Which function should the analyst use?: COUNT DISTINCT
20. An analyst is working in a database and needs to use a function