- All Exams Instant Download
Which of the following variable name formats would be problematic if used in the majority of data software programs?
Which of the following variable name formats would be problematic if used in the majority of data software programs?A . First_Name_B . FirstNameC . First_NameD . First NameView AnswerAnswer: D Explanation: This is because First Name is a variable name format that would be problematic if used in most of...
Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the Quantity_sold column?
A data analyst has been asked to derive a new variable labeled “Promotion_flag” based on the total quantity sold by each salesperson. Given the table below: Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the...
Which of the following should be the total number of datapoints on the next day?
An analyst runs a report on a daily basis, and the number of datapoints must be validated before the data can be analyzed. The number of datapoints increases each day by approximately 20% of the total number from the day before. On a given day, the number of datapoints was...
Which of the following conclusions is accurate at a 95% confidence interval?
An e-commerce company recently tested a new website layout. The website was tested by a test group of customers, and an old website was presented to a control group. The table below shows the percentage of users in each group who made purchases on the websites: Which of the following...
The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state.
The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following: * County outages * Status * Overall trend...
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...
