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: Data analysts usually use _____ to deal with very large datasets. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What are some of the benefits of using SQL for analysis? Select all that apply. 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 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 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 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 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 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 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 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 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 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 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 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 The V in VLOOKUP stands for what? 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 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 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 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 20142683 for the employee in row 3? 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 Burlington, MA, what is the correct function? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: A predetermined structure that includes a function’s required information and its proper placement is called _____. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst uses the SPLIT function to divide a text string around a specified character and put each fragment into a new, separate cell. What is the specified character separating each item called? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: Conditional formatting is a spreadsheet tool that changes how _____ appear when values meet a specific condition. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions