- All Exams Instant Download
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:
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 systems is the most appropriate?
Alex wants to use data from his corporate sale, CRM, and shipping systems to try and predict future sales. Which of the following systems is the most appropriate? Choose the best answer.A . Data mart.B . OLAP.C . Data Warehouse.D . OLTP.View AnswerAnswer: C Explanation: Correct answer: C. Data Warehouse....
Which of the following is the MOST likely cause of the issue?
A recurring event is being stored in two databases that are housed in different geographical locations. A data analyst notices the event is being logged three hours earlier in one database than in the other database. Which of the following is the MOST likely cause of the issue?A . The...
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,...
