- All Exams Instant Download
Which of the following BEST describes the data set?
Refer to the exhibit. Given the following data: Which of the following BEST describes the data set?A . There is data bias.B . The data is incomplete.C . The data is inconsistent.D . The data is outliers.View AnswerAnswer: C Explanation: This is because inconsistency is a type of data quality...
Which of the following summary statements upholds integrity in data reporting?
Refer to the exhibit. Given the following graph: Which of the following summary statements upholds integrity in data reporting? A. Sales are approximately equal for Product A and Product B across all strategies. B. Strategy 4 provides the best sales in comparison to other strategies. C. While Strategy 2 does...
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 data manipulation techniques should the data analyst use to create "Income Categories"?
A data analyst wants to create "Income Categories" that would be calculated based on the existing variable "Income". The "Income Categories" would be as follows: Income category 1: less than $1. Income category 2: more than $1 and less than $20,000. Income category 3: more than $20,001 and less than...
Which of the following data schemas shown?
Refer to the exhibit. Given the diagram below: Which of the following data schemas shown?A . Key-value pairsB . Online transactional processingC . Data LakeD . Relational databaseView AnswerAnswer: D Explanation: A relational database is a type of database that organizes data into tables, where each table has a fixed...
Which of the following MDM processes needs to take place FIRST?
Refer to the exhibit. Given the following data tables: Which of the following MDM processes needs to take place FIRST?A . Creation of a data dictionaryB . Compliance with regulationsC . Standardization of data field namesD . Consolidation of multiple data fieldsView AnswerAnswer: A Explanation: This is because a data...
Which of the following would be the BEST way to provide this visibility?
A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals’ earned commissions and projected commissions based on sales, but they want that information to be kept confidential. Which of the following would be the BEST way to...
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 appropriate descriptive statistic to use?
A cereal manufacturer wants to determine whether the sugar content of its cereal has increased over the years. Which of the following is the appropriate descriptive statistic to use?A . FrequencyB . Percent changeC . VarianceD . MeanView AnswerAnswer: B Explanation: This is because percent change is a type of...
The number of phone calls that the call center receives in a day is an example of:
The number of phone calls that the call center receives in a day is an example of:A . continuous data.B . categorical data.C . ordinal data.D . discrete data.View AnswerAnswer: D Explanation: Discrete data is a type of data that can only take certain values, usually whole numbers or integers....
