IT Specialist : Data Analytics Practice Exam 1. Your manager has provided you with a group of random data. The data contains customer information like name, age, address, phone, order number, and email. Your manager asks for a report that shows spending by age group. To generate this report, you need to remove any unneeded data. Which data manipulation should you perform? A. Append B. Truncate C. Sorting D. Filtering 2. You are provided with this table of past, present, and future sales data. Year 2020 2021 2022 2023 2024 2025 Product A $75000 $80000 $70000 $50000 $20000 $15000 Product B $40000 $40000 $45000 $55000 $85000 $90000 Product C $25000 $30000 $35000 $35000 $550000 $45000 You need to create a chart that allows you to visualize and compare the relative sales of the three products for each year. Which chart should you create? A. Bar chart B. Scatter plot C. Pie chart D. Line graph 3. Which statement describes a problem solved through predictive analytics? A. Testing whether the change in the price of a stock is statistically significant B. Deciding whether one should buy or sell a stock based on various possibl scenarios for its price C. Explaining why the price of a certain stock fell sometime last year D. Estimating the future price of a stock based on past data from the stock market 4. For each statement about accuracy and interpretability, select Yes if it is true or No if it is false. A. Highly accurate models tend to be very complex and challenging for humans to explain why a model produced a given output. Answer:YES B. If a researcher wants to explain why a patient is more likely to get diagnosed with a disease, then the researcher should use a model that prioritizes interpretability. Answer:YES C. Highly interpretive models are good at analyzing non-linear relationships that tend to require long computation time. Answer:NO 5. Your manager views this graph and wants to know how to stop the downward trend. Which type of analysis should you use to provide this information? A. Descriptive B. Diagnostic C. Prescriptive D. Predictive