IT Specialist : Data Analytics Practice Exam 1. Move each data cleaning process from the list on the left to the correct description on the right. A. Removes unwanted spaces before or after text or a number Answer:TRIMMING. B. Removes multiple instances of the same data Answer:Removing Duplicates C. Checks data against a list of verified data values Answer:Validating D. Transforming data to a common standard Answer:Formatting E. Removing missing or NULL values or replacing them with an appropriate replacement value Answer:Missing Data Handling 2. You have the following logical database design for a three-dimensional (3-D) printing facility. The MachinelD field in Object relates to the ID field in Machine. The MachinelD field in Assignment relates to the ID field in Machine. The OperatorID field in Assignment relates to the ID field in Operator. The ObjectiD in the Stamp field relates to the ID field in Object No constraints are defined You need to determine the type of relationships that exist among the entities. Answer each question by selecting the correct option from each drop-down list. A. What kind of relationship exists between Machine and Operator? Answer:Many-to-Many B. What kind of relationship exists between Machine and Object? Answer:One-to-Many C. What kind of relationship exists between Object and Stamp? Answer:One-to-One 3. In which situation would you need to disaggregate data before creating a report? A. When the data only reports a group-level summary statistics table, but you need individual-level insights B. When the data contains sensitive information, and you need to encrypt or tokenize the dataset C. When the data contains a hierarchical structure, and you need to report on different levels of its hierarchy D. When the data is randomly shuffled, and you need to create an inherent order before proceeding to analyze it 4. You are processing data in a table. Which area represents the first row of data? Select a row in the answer area A. B. C. D. Answer:C 5. What data type would X store in the equation shown below? X = (1==3) A. Boolean B. String C. Float D. Integer 6. You are analyzing a large sales data source that contains quantity and selling price for every item sold. The data source is sorted by selling price from the lowest price to the highest price. You need to determine which selling price is in the middle. What aggregate function should you use? A. Average/Mean B. Median C. Standard Deviation D. Mode 7. You are working as a data analyst for your company. You have been tasked with analyzing a large data set to determine trends over time. You need to determine the most suitable chart to display your analysis. Which type of chart is suitable for displaying this kind of analysis? A. Barchart B. Line chart C. Gantt chart D. Pie chart 8. Move each data structure from the list on the left to the correct description on the right A. A grid-like combination of observations and variables or records and properties Answer:Table B. Holds all properties for a single instance or observation. Also known as record or observation Answer:Row C. Holds a single property or variable for all records or observations. Also known as attributes or analytical variables. Answer:Column 9. You are analyzing sales data from the last four years. What conclusion can you derive from the following chart? A. Minnie sold the fewest items each year. B. Taylor sold the most items each year. C. Taylor has the highest total sales. D. The company is profitable 10. A researcher has seen studies indicating fewer women are majoring in computer science than men. The researcher personally knows several women majoring in computer science, so he discounts those studies as outdated Which type of bias affected the researcher's decision? A. Sampling B. Confirmation C. Anchoring D. Availability