WGU D465 - Data Applications PA 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 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 An analyst working to aggregate data in databases uses a Structured Query Language (SQL) command to create a temporary name for a table and receives an ERROR message when the command is used. Which command does the analyst use to create a temporary name for a table? FROM 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 An analyst is working in a database and needs to use a function that will return all the records from one table and only the matching records from a second table. How does the analyst determine the order of the tables using a JOIN function? The table mentioned first is on the left. An analyst is working on a spreadsheet and notices that rows and columns that should remain unchanged are changing when they are copied. This data set is generally problematic, and the analyst is trying to solve many problems under time constraints. What does the analyst do to correct this issue with the dataaggregation process as quickly as possible? Lock the table array part of the function An analyst working in Google Sheets wants to find the lowest possible average of monthly sales in a range of values. Which function should the analyst use? MIN An analyst working in Google Sheets wants to calculate the total revenue of each transaction recorded. Each transaction can have exactly one item type and the data is organized by a category other than quantity. Which function should the analyst use? SUMIF