Which of the following defines the policies and procedures for managing the master data?
Correct Answer: D
Comprehensive and Detailed In-Depth Explanation: Data governance encompasses the overall management of data availability, usability, integrity, and security within an organization. It involves establishing policies and procedures to ensure that data is managed effectively and consistently across the organization. Option A:Data administration * Rationale:Data administration focuses on the technical aspects of managing data assets, including database management and maintenance. While important, it does not encompass the broader policy- making scope of data governance. Option B:Data stewardship * Rationale:Data stewardship involves overseeing the lifecycle of data, ensuring its quality and proper usage. Stewards implement the policies set forth by data governance but do not define those policies themselves. Option C:Data ownership * Rationale:Data ownership assigns responsibility for specific data assets to individuals or departments. Owners are accountable for the data but do not establish the overarching policies and procedures. Option D:Data governance * Rationale:Data governance is the framework that defines the policies and procedures for managing master data, ensuring consistency, quality, and protection across the organization.
Question 17
Which of the following are reasons to conduct data cleansing? (Select two).
Correct Answer: C,F
Two reasons to conduct data cleansing are: * To improve accuracy: Data cleansing helps to ensure that the data is correct, consistent, and reliable. This can improve the quality and validity of the analysis, as well as the decision-making and outcomes based on the data12 * To calculate trends: Data cleansing helps to remove or resolve any errors, outliers, or missing values that could distort or skew the data.This can help to identify and measure the patterns, changes, or relationships in the data over time13
Question 18
An analyst is reviewing the following data: Car IDSpeed 123155 566436 564418 650567 546436 645638 Which of the following should the analyst include in the measures of central tendency for speed?
Correct Answer: D
The measures of central tendency include the mode, median, and mean. The mode is the value that appears most frequently in a data set. In this case, the speed of 36 appears twice, making it the mode. The median is the middle value when a data set is ordered from least to greatest; for these speeds, when ordered (18, 36, 36, 38, 55, 67), the median is the average of the two middle numbers, which is ( \frac{36 + 38}{2} = 37 ). The mean is the average of all values, calculated as ( \frac{55 + 36 + 18 + 67 + 36 + 38}{6} = 41.7 ). Reference: The calculation of the mode, median, and mean is based on standard statistical formulas and definitions. The measures of central tendency for speed include the mode, median, and mean. To calculate these, we first need to organize the data: Speeds in ascending order: 18, 36, 36, 38, 55, 67 Mode is the value that appears most frequently, which is 36, as it appears twice. Median is the middle value when the data is ordered. Since we have an even number of observations, we take the average of the two middle values (36 and 38), resulting in 37. Mean is the sum of all values divided by the number of values.(18+36+36+38+55+67)/6=41.5(18+36+36+38+55+67)/6=41.5. Thus, the correct option is D, which includes Mode = 36, Median = 37, and Mean = 41.5. The range, maximum, and minimum values, although useful in understanding data dispersion, are not measures of central tendency and are therefore not relevant to this specific question.
Question 19
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 Quantity_sold column?
Correct Answer: C
Explanation A logical function is a type of function that returns a value based on a condition or a set of conditions. For example, the IF function in Excel can be used to check if a certain condition is met, and then return one value if true, and another value if false. In this case, the data analyst can use a logical function to check if the Quantity_sold column is greater than 1,000,000, and then return "Yes" if true, and "No" if false. This would create a new variable called Promotion_flag that indicates whether the salesperson has sold more than 1,000,000 units or not. References: CompTIA Data+ Certification Exam Objectives, Logical functions (reference)
Question 20
Which of the following contains alphanumeric values?
