Exam (elaborations) D204

dentifying business needs - ANSWER Which activity does an analyst perform in the discovery phase of the data analytics life cycle? a. Collecting Data b. Cleaning Data c. Identifying outliers d. Identifying business needs Data Exploration - ANSWER In which phase of the data analytics life cycle does an analyst build a histogram? a. Data acquisition b. Data exploration c. Discovery d. Predictive modeling Exploratory data analysis - ANSWER An analyst applies a statistical formula to obtain the average temperature for a city over the last 50 years. Which phase of the data analytics life cycle is represented by this activity? a. Data acquisition b. Exploratory data analysis c. predictive modeling d. Data reporting Detecting missing values - ANSWER An analyst has been tasked with defining data columns that could contain null values. Which activity of the data acquisition phase is represented? a. collecting data b. disqualifying data sources c. detecting missing values d. transforming improperly formatted text Cleaning Data - ANSWER Which activity in the data analytics life cycle occurs during the data acquisition phase and requires the most time and effort from the data analyst? a. selecting the data sources b. importing data into a database c. cleaning data defining goals The SQL queries of data within the tables - ANSWER What might be developed by data analysts when acquiring data from a data warehouse? a.The procedures for extracting files from the data warehouse b. The procedures for updating tables in the data warehouse c. The relational structure of tables d. The SQL queries of data within the tables