Layer 1 A data analyst commits a query to the repository as a new and improved query. Then, they specify the changes they made and why they made them. This scenario is part of what process? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: Once data is clean, a data analyst moves on to _____ and verification. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst uses a changelog while cleaning data. What process does a changelog support? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which of the following functions automatically remove extra spaces when cleaning data? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst is in the verification step. They consider the business problem, the goal, and the data involved in their analytics project. What scenario does this describe? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Reviewing version history is an effective way to view a changelog in SQL. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst uses the COUNTA function to count which of the following? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: TRIM is a function that removes _____ spaces in data. Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: A changelog contains a _____ list of modifications made to a project. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What is the first step in the verification process? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 While verifying cleaned data, a data analyst encounters a misspelled name. Which function can they use to determine if the error is repeated throughout the dataset? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which SQL tool considers one or more conditions, then returns a value as soon as a condition is met? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: A data analyst uses the CASE statement to consider one or more _____, then returns a value. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What tool can a data analyst use to figure out how many identical errors occur in a dataset? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What is the process of tracking changes, additions, deletions, and errors during data cleaning? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: While cleaning data, a data analyst can use a changelog to keep a chronological list of changes they make. They can refer to it during the _____ period if there are errors or questions. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 At what point during the analysis process does a data analyst use a changelog? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 As the survey has too few responses and numerous duplicates that are skewing results, what are your options? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 She says: Spreadsheets have a great tool for that called remove duplicates. In SQL, you can include DISTINCT to do the same thing. In which part of the SQL statement do you include DISTINCT? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What function would you use to search for a certain value in a spreadsheet column to return the corresponding piece of information? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 She asks: What is the TRIM function used for in SQL? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 She asks: Is there a SQL function that can convert data types such as currency, dates, and times in a SQL table? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Without enough data to identify long-term trends about the video subjects that people prefer, what are your available options? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You decide to use a spreadsheet function to divide the text strings in Column G around the commas and put each fragment into a new, separate cell. You are using the SPLIT function. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions