Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?
Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?A . SASB . Microsoft Power BIC . IBM SPSSD . PythonView AnswerAnswer: D Explanation: Python is a common data analytics tool that is also used as an interpreted, high-level,...
Which of the following charts would be BEST to use?
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 would be the BEST method to automate and ensure successful delivery for this task?
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...
Which of the following is a characteristic of a relational database?
Which of the following is a characteristic of a relational database?A . It utilizes key-value pairs.B . It has undefined fields.C . It is structured in nature.D . It uses minimal memory.View AnswerAnswer: C Explanation: It is structured in nature. This is because a relational database is a type of...
Which of the following should the data analyst use to BEST communicate this information to the manager?
A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?A...
Which of the following are the most common issues?
The ACME Corporation hired an analyst to detect data quality issues in their Excel documents. Which of the following are the most common issues? (Select TWO)A . Apostrophe.B . Commas.C . Symbols.D . Duplicates.E . Misspellings.View AnswerAnswer: D, E Explanation:
The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:
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...
Which of the following should be included in the report?
A data analyst has been asked to create an ad-hoc sales report for the Chief Executive Officer (CEO). Which of the following should be included in the report?A . The sales representatives' home addresses.B . Line-item SKU numbers.C . YTD total sales.D . The customers' first and last names.View AnswerAnswer:...
Which of the following date ranges should be on the report?
A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?A . January 1, 2020...
Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?
Given the following customer and order tables: Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?A . Five rows, eight columnsB . Seven rows, eight columnsC . Eight rows, seven columnsD . Nine rows,...