DA0-001 exam

While reviewing survey data, a research analyst notices data is missing from all the responses to a single question. Which of the following methods would BEST address this issue?A . Replace missing data.B . Remove duplicate data.C . Replace redundant data.D . Remove invalid data.View AnswerAnswer: A Explanation: This is...

A data analyst has been asked to create a sales report that calculates the rolling 12-month average for sales. If the report will be published on November 1, 2020, which of the following months shouts the report cover?A . October 1, 2019 to October 31, 2020B . October 31, 2020...

Consider the following dataset which contains information about houses that are for sale: Which of the following string manipulation commands will combine the address and region name columns to create a full address? full_address------------------------- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern Metropolitan 5 Charles St, Northern Metropolitan 40...

An analyst is working with the income data of suburban families in the United States. The data set has a lot of outliers, and the analyst needs to provide a measure that represents the typical income. Which of the following would BEST fulfill the analyst’s goal?A . MedianB . MeanC...

Refer to the exhibit. Given the following report: Which of the following components need to be added to ensure the report is point-in-time and static? (Choose two.)A . A control group for the phrasesB . A summary of the KPIsC . Filter buttons for the statusD . The date when...

An analyst needs to provide a chart to identify the composition between the categories of the survey response data set: Which of the following charts would be BEST to use?A . HistogramB . PieC . LineD . Scatter potE . WaterfallView AnswerAnswer: B Explanation: A pie chart is the best...

Which of the following can be used to translate data into another form so it can only be read by a user who has a key or a password?A . Data encryption.B . Data transmission.C . Data protection.D . Data masking.View AnswerAnswer: A Explanation: Data encryption can be used to...

A data analyst needs to create a weekly recurring report on sales performance and distribute it to all sales managers. Which of the following would be the BEST method to automate and ensure successful delivery for this task?A . Use scheduled report delivery.B . Implement subscription access delivery.C . Print...

The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:A . a t-test.B . a performance analysis.C . an exploratory data analysis.D . a link analysis.View AnswerAnswer: C Explanation: This is because exploratory data analysis is...

A data analyst must separate the column shown below into multiple columns for each component of the name: Which of the following data manipulation techniques should the analyst perform?A . ImputingB . TransposingC . ParsingD . ConcatenatingView AnswerAnswer: C Explanation: Parsing is the data manipulation technique that should be used...