Layer 1 A data analyst is managing a database of customer information for a retail store. What SQL command can the analyst use to add a new customer to the database? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: _____ refers to the process of converting data from one type to another. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 The CAST function can be used to convert the DATE datatype to the DATETIME datatype. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In which of the following situations would a data analyst use spreadsheets instead of SQL? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 The analyst wants to retrieve the first two letters of each state so that all the entries are consistent and only contain 2 letters. What is the correct SQL clause to retrieve the first two letters of each state? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: In SQL databases, the _____ function can be used to convert data from one datatype to another. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst is cleaning survey data. The results for an optional question contain many nulls. What function can the analyst use to eliminate the null values from the results? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What SQL function lets you add strings together to create new text strings that can be used as unique keys? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst runs a SQL query to extract some data from a database for further analysis. How can the analyst save the data? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 The analyst wants to return a list of all unique customer IDs to identify the states in which they have customers. What is the correct SQL clause to retrieve the customer IDs? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: The _____ function counts the number of characters a string contains. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst at an e-commerce company is working with a spreadsheet containing last month’s sales. The most expensive product their company sells costs $49.99, so they want to quickly confirm that all of the data in the Sales column is $49.99 or less. What function can they use? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst at a nonprofit organization is working with a spreadsheet that contains member name data in column C. They want to divide this data so that first names are stored in one column and last names in another. Which tool should the analyst use? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 For a function to work properly, data analysts must follow each function’s predetermined structure. What is this structure called? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 The V in VLOOKUP stands for what? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 New postaTo evaluate how well two or more data sources work together, data analysts use data mapping. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In order to extract the five-digit postal code from North Wales, PA, what is the correct function? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 An analyst is cleaning a new dataset containing 500 rows. They want to make sure the data contained from cell B2 through cell B300 does not contain a number greater than 50. Which of the following COUNTIF function syntaxes could be used to answer this question? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A delimiter is a character that indicates the beginning or end of a data item. The split text to columns tool uses a delimiter to accomplish what task? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A predetermined structure that includes all required information and its proper placement in a formula or function is called syntax. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In order to extract the five-digit postal code from Brandon, FL, what is the correct function? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 They want to create employee identification numbers (IDs) in column D. The IDs should include the year hired plus the last four digits of the employee’s Social Security Number (SS#). What function will create the ID 20201939 for the employee in row 4? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst wants to search for a certain value in a column, then return a corresponding piece of information. Which function should they use? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst needs to combine two datasets. Each dataset comes from a different system, and the systems store data in different ways. What can the data analyst do to ensure the data is compatible? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
