CompTIA DA0-001 Practice Test - Questions Answers, Page 33

A data analyst has been asked to create one table that has each employee's first name, last name, sales, and address. The sales and addresses are listed in the tables below:

Which of the following steps should the analyst take to create the table?

Which of the following types of analyses should be used to evaluate the connections and anomalies in a data set when either known patterns are being violated or new patterns are emerging?

Which of the following data manipulation techniques should an analyst use to hide unnecessary data during analysis?

An analyst wants to create a historical data set for the past five years with each year in its own data set. Which of the following methods is the best way to create this historical data set?

A data set for sales per month includes the following data:

Which of the following cleaning and profiling methods should be applied to the data set?

The total values in this month's revenue report are twice as much as last month's. Which of the following most likely occurred during the ETL process?

An analyst is reporting on the average income for a county and is reviewing the following data:

Which of the following is the reason the analyst would need to cleanse the data in this data set?

A company wants to know how its customers interact with an e-commerce website based on clicks over items. Which of the following is the primary requirement for this report?

Which of the following is the best reason for removing data outliers?